DISABLE_DATA_CACHE (SELECT Option)

DISABLE_DATA_CACHE causes the query to ignore cached views. This option is useful for queries that require the latest data rather than cached data.

If this option is not specified, cached data is used whenever 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_data_cache

Example

SELECT {OPTION disable_data_cache} * FROM cachedView1