Query Cache SELECT
Options
Two query cache-related options may be specified in SELECT
statements:
SQL_CACHE
The query result is cached if it is cacheable and the value of the
query_cache_type
system variable isON
orDEMAND
.SQL_NO_CACHE
The query result is not cached.
Examples: