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

SQL Optimizer for DB2 ZOS 5.6.2 - User Guide

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

DIXSCAN

Represents access by XML DOCID index scan.

 

EXCEPT

Denotes the EXCEPT operation.

This operation returns rows in the outer table only and eliminates redundant duplicate rows.

 

EXCEPTA

Denotes the EXCEPT ALL operation.

This operation returns rows in the outer table only and retains redundant duplicate rows.

 

FETCH

Represents the retrieval of columns for a row.

The FETCH operator uses RIDs from an IXSCAN or MIXSCAN.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation