enable_result_cache_for_session - Amazon Redshift


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