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.

• CASE_SENSITIVE (SELECT Option)
• DISABLE_CBO (SELECT Option)
• DISABLE_DATA_CACHE (SELECT Option)
• DISABLE_DATA_CACHE_IMMEDIATE (SELECT Option)
• DISABLE_JOIN_PRUNER (SELECT Option)
• DISABLE_PLAN_CACHE (SELECT Option)
• DISABLE_PUSH (SELECT Option)
• DISABLE_SELECTION_REWRITER (SELECT Option)
• DISABLE_SORT_REMOVAL (SELECT Option)
• DISABLE_STATISTICS (SELECT Option)
• DISABLE_THREADS (SELECT Option)
• FORCE_DISK (SELECT Option)
• FORCE_ESTIMATION (SELECT Option)
• IGNORE_TRAILING_SPACES (SELECT Option)
• MAX_ROWS_LIMIT (SELECT Option)
• ROWS_OFFSET (SELECT Option)
• STRICT (SELECT Option)
• PUSH_NULL_SELECTS (SELECT OPTION)
• DISABLE_CONSTANT_FUNCTION_INLINING (SELECT OPTION)
• DISABLE_UNION_PREAGGREGATOR (SELECT OPTION)
• USE_COMPARABLE_ESTIMATES (SELECT OPTION)