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.