DISABLE_STATISTICS (SELECT Option)

Reference Guide > TDV Query Engine Options > SELECT Options > DISABLE_STATISTICS (SELECT Option)

DISABLE_STATISTICS causes the query engine to ignore table statistics when preparing a query execution plan. This option can be useful for checking whether statistics gathering improves the query execution plan.

If this option is not specified, the query engine uses all available statistics to optimize the query execution plan.

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_statistics

Example

SELECT {OPTION disable_statistics} * FROM table1

WHERE column1 = 5