DISABLE_PLAN_CACHE (SELECT Option)
DISABLE_PLAN_CACHE causes the query engine to prepare a fresh query plan each time it executes the query. If DISABLE_PLAN_CACHE is not specified, the query engine uses a cached plan whenever one is available.
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_plan_cache
Example
SELECT {OPTION disable_plan_cache} * FROM table1