enable_result_cache_for_session - Amazon Redshift
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).


Values (default in bold)

on (true), off (false)


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.


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