Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

enable_result_cache_for_session

Values (default in bold)

on (true), off (false)

Description

Specifies whether to use query results caching. If enable_result_cache_for_session is on, Amazon Redshift checks for a valid, cached copy of the query results when a query is submitted. If a match is found in the result cache, Amazon Redshift uses the cached results and doesn’t run the query. If enable_result_cache_for_session is off, Amazon Redshift ignores the results cache and runs all queries when they are submitted.

Example

SET enable_result_cache_for_session TO off;
--Amazon Redshift now ignores the results cache