What is required for a query execution to be served from the result cache?
What is required for a query execution to be served from the result cache?
For a query execution to be served from the result cache, the SQL texts must be the same. Any difference in the SQL text, such as whitespace, capitalization, or literal values, will result in the query being treated as a different one and will not benefit from the cache.
The query text (SQL) must be identical for the query execution to be served from the result cache. If a query differs in any aspect of its SQL text, such as whitespace, capitalization, or literal values, it is considered a different query and will not be served from the result cache
B https://docs.snowflake.com/en/user-guide/querying-persisted-results Typically, query results are reused if all of the following conditions are met: The new query matches the previously executed query exactly. Any difference in syntax, including lowercase versus uppercase, or the use of table aliases, will inhibit 100% cache reuse. For example, consider the following queries, run in succession: SELECT DISTINCT(severity) FROM weather_events; SELECT DISTINCT(severity) FROM weather_events; SELECT DISTINCT(severity) FROM weather_events we; select distinct(severity) from weather_events; The first query will populate the cache, and the identical second query will benefit from 100% cache reuse. However, the third and fourth queries will not trigger cache reuse, simply because the third query introduces a table alias and the fourth query uses lowercase keywords.
I thin D "Result Cache: Which holds the results of every query executed in the past 24 hours. These are available across virtual warehouses, so query results returned to one user is available to any other user on the system who executes the same query, provided the underlying data has not changed." https://community.snowflake.com/s/article/Caching-in-the-Snowflake-Cloud-Data-Platform
Correct
B - same SQL text