SEMIJOIN

SQL Optimizer for IBM DB2 z/OS

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.