A sales table FCT_SALES has 100 million records.
The following query was executed:
SELECT COUNT (1) FROM FCT_SALES;
How did Snowflake fulfill this query?
A sales table FCT_SALES has 100 million records.
The following query was executed:
SELECT COUNT (1) FROM FCT_SALES;
How did Snowflake fulfill this query?
Snowflake fulfills the query SELECT COUNT(1) FROM FCT_SALES by querying against the metadata cache. This approach is efficient for aggregations like COUNT because Snowflake stores metadata about the tables which can quickly provide the number of records without scanning the entire 100 million records in the sales table.
D. Query against the metadata cache >> METADATA-BASED RESULT
D. Query against the metadata cache
Correct
D is correct
D.Query against the metadata cache