SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

EXCEPT

Denotes the EXCEPT operation.

This operation returns rows in the outer table only and eliminates redundant duplicate rows.

EXCEPTA

Denotes the EXCEPT ALL operation.

This operation returns rows in the outer table only and retains redundant duplicate rows.

FETCH

Represents the retrieval of columns for a row.

The FETCH operator uses RIDs from an IXSCAN or MIXSCAN.

FFETCH

Employs a fact table index in order to fetch a fact table in a data manager pushdown star join.