FORCE_DISK (SELECT Option)
FORCE_DISK forces the query engine to use disk instead of memory for temporary storage of query data. This frees up memory for other server operations. This option is useful for queries that can consume large amounts of memory and affect performance of other processes running on the server.
If FORCE_DISK is not specified, the query engine uses memory rather than disk whenever possible to maximize performance.
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
force_disk
Example
SELECT {OPTION force_disk} *
FROM table1 INNER JOIN table2 ON table1.id = table2.id
INNER JOIN table3 ON table1.id = table3.id