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