This page has not been translated into your language. Request translation

enable_result_cache_for_session

PDFRSS

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