DISABLE_THREADS (JOIN Option)
DISABLE_THREADS can be used to prevent the query engine from using background threads to speed up processing of queries. You can use this option to prevent resource-intensive queries from using excessive server resources.
If DISABLE_THREADS is not specified, the query engine always uses background threads to speed up processing.
This JOIN option takes precedence over the SELECT-level DISABLE_THREADS option.
Operator
JOIN
Syntax
disable_threads
Example
SELECT column1 FROM table1 INNER {OPTION disable_threads}
JOIN table2 ON table1.id = table2.id SELECT column1 FROM table2