SQL Queries without using cache

From UFP-UV Sakai Wiki

Jump to: navigation, search

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 is ON or DEMAND.
  • SQL_NO_CACHE
The query result is not cached.

Examples:

-- WITH cache
SELECT SQL_CACHE id, name FROM customer;
 
-- WITHOUT cache
SELECT SQL_NO_CACHE id, name FROM customer;
Personal tools