Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for DB2 ZOS 5.6.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Third-party contributions Copyright

MERGESTMT

Denotes the MERGE statement.

This node merges the conditional UPDATE and INSERT operation on a target table or view into one statement.

 

MIXSCAN

Scan a multiple-index.

 

MSJOIN

Use to perform a merge join.

 

NLJOIN

Use to perform a nested loop join.

This join is used to join tables and is represented by a NLJOIN node and right and left subtrees. The inner table is represented by the right subtree and the outer table by the left subtree. Use either a single-index scan, a multiple-index scan, or a table space scan to access both the inner and outer tables. You can also include another join operation with the left subtree.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation