UNION, INTERSECT, and EXCEPT Options

Reference Guide > TDV Query Engine Options > UNION, INTERSECT, and EXCEPT Options

UNION, INTERSECT, and EXCEPT Options

The following query engine hints are available for the three set operations UNION, INTERSECT, and EXCEPT:

• DISABLE_PUSH (UNION, INTERSECT, and EXCEPT Option)

• FORCE_DISK (UNION, INTERSECT, and EXCEPT Option)

• PARALLEL (UNION, INTERSECT, and EXCEPT Option)

• ROUND_ROBIN (UNION, INTERSECT, and EXCEPT Option)

• SORT_MERGE (UNION, INTERSECT, and EXCEPT Option)