What is used during the FIRST execution of SELECT COUNT(*) FROM ORDER?
What is used during the FIRST execution of SELECT COUNT(*) FROM ORDER?
When executing SELECT COUNT(*) FROM ORDER for the first time, a metadata-based result is used. Metadata keeps information about the row count without needing to access the actual data, making it efficient for such queries.
D correct - https://community.snowflake.com/s/question/0D5Do00000IaCZlKAN/what-is-the-difference-between-metadata-cache-and-result-cache
Metadata keeps information about the row count