SELECT Options
The following query engine hints are available for SELECT. These options are specified immediately following the SELECT keyword.
Examples
SELECT {OPTION FORCE_DISK}
SELECT {OPTION FORCE_DISK="FALSE"}
SELECT {OPTION STRICT}
Operator-level options (such as JOIN-level options) override SELECT-level options.
SELECT options should be specified at the root-level of the query. When SELECT options are specified as part of a subquery or subselect, they might not affect the root-level query execution plan.