Chat now with support
Chat mit Support

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

MERGESTMT

Welcome > SQL Operations > MERGESTMT

Denotes the MERGE statement.

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

 

MIXSCAN

Welcome > SQL Operations > MIXSCAN

Scan a multiple-index.

 

MSJOIN

Welcome > SQL Operations > MSJOIN

Use to perform a merge join.

 

NLJOIN

Welcome > SQL Operations > 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.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen