Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright


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.



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 result set in the order specified from the join process or the query.



Denotes operation where DB2 sorts qualified index entries.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating