立即与支持人员聊天
与支持团队交流

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright

UNIONA

Combine rows from multiple tables and retain duplicate rows.

An UNION ALL construct contains a UNIONA node and at least one subtree. Subtrees denote any source query blocks.

 

UPDATE

Modify rows in a table.

An update construct contains one UPDATE node and one of the following: single-index access, multiple-index access construct, or table space scan.

 

UPDCUR

Represents UPDATE WHERE CURRENT OF CURSOR value.

 

WFSCAN

Scan a work file.

A work file scan construct contains a WFSCAN node plus a work file node that is labeled WORKFILE.

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级