SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

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

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

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

SORTRID

Denotes operation where DB2 sorts qualified index entries.