DISABLE_PUSH (UNION, INTERSECT, and EXCEPT Option)

Reference Guide > TDV Query Engine Options > UNION, INTERSECT, and EXCEPT Options > DISABLE_PUSH (UNION, INTERSECT, and EXCEPT Option)

DISABLE_PUSH causes UNION, INTERSECT, and EXCEPT operators to be processed locally in TDV Server instead of being pushed to the data source. If DISABLE_PUSH is not specified, UNION, INTERSECT, and EXCEPT operators are pushed to the data source whenever possible.

Operators

UNION, INTERSECT, EXCEPT

Syntax

disable_pusH

Example

SELECT column1 FROM table1

UNION ALL {OPTION disable_pusH}

SELECT column1 FROM table2