DISABLE_PUSH (JOIN Option)

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

DISABLE_PUSH causes the query engine to process the JOIN operator locally instead of pushing it to the data source. If DISABLE_PUSH is not specified, the JOIN operator is pushed to the data source whenever possible.

Operator

JOIN

Syntax

disable_push

Example

SELECT column1 FROM table1 INNER {OPTION disable_push}

JOIN table2 ON table1.id = table2.id