DISABLE_THREADS (SELECT Option)
DISABLE_THREADS prevents the query engine from using background threads to speed up processing. This option can be used to prevent resource-intensive queries from using excessive TDV resources. If DISABLE_THREADS is not specified, the query engine always uses background threads to speed up processing.
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_threads
Example
SELECT {OPTION disable_threads} *
FROM table1 INNER JOIN table2 ON table1.id = table2.id
INNER JOIN table3 ON table1.id = table3.id