DISABLE_PUSH (ORDER BY Option)

Reference Guide > TDV Query Engine Options > ORDER BY Options > DISABLE_PUSH (ORDER BY Option)

DISABLE_PUSH forces the ORDER BY operator to be processed locally in TDV Server instead of being pushed to the data source. If DISABLE_PUSH is not specified, the ORDER BY operator is pushed to the data source whenever possible.

Operator

ORDER BY

Syntax

disable_push

Example

SELECT column1 FROM table1

ORDER BY {OPTION disable_push} column1