SEMIJOIN From SQL Optimizer for IBM DB2 z/OS previous page next page 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. previous page start next page