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

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

SELUPD

Welcome > SQL Operations > SELUPD

Denotes value SELECT with FOR UPDATE OF.

 

SEMIJOIN

Welcome > SQL Operations > SEMIJOIN

Use to perform a semi join.

During a hybrid join, this node denotes a join operation where the outer table records merge with one of the indexes on the inner table.

 

SIXSCAN

Welcome > SQL Operations > SIXSCAN

Access and scan with a sparse index.

A sparse index scan construct contains two nodes: a SIXSCAN node and a sparse index node labeled SPARSE INDEX.

 

SORT

Welcome > SQL Operations > SORT

Sort result set in the order specified from the join process or the query.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation