DISABLE_PUSH (SELECT Option)

Reference Guide > TDV Query Engine Options > SELECT Options > DISABLE_PUSH (SELECT Option)

DISABLE_PUSH causes the SELECT to be processed locally in TDV Server instead of being processed at the data source. If DISABLE_PUSH is not specified, the SELECT is pushed to the data source whenever possible.

Note: When SELECT options are specified as part of a subquery or subselect, they might not affect the root-level query execution plan.

Operator

SELECT

Syntax

disable_push

Example

SELECT {OPTION disable_push} column1 FROM table1 INNER JOIN table2 ON table1.id = table2.id