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

IXAND

Welcome > SQL Operations > IXAND

Represents the intersection of two sorted ROWID lists. Output includes only ROWIDs in both lists.

 

IXOR

Welcome > SQL Operations > IXOR

Return the union of two sorted ROWID lists.

Output includes any ROWID that is present in at least one ROWID list. The output removes duplicate ROWIDs.

 

IXSCAN

Welcome > SQL Operations > IXSCAN

Use an index to retrieve the rows.

 

MERGE

Welcome > SQL Operations > MERGE

Merge multiply data streams into a single data stream.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation