COF-C02 · Question #252
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
The correct answer is D. Pruning. Snowflake uses a technique called micro-partition pruning (partition pruning) to avoid scanning irrelevant micro-partitions. Snowflake automatically stores metadata (min/max values, distinct value counts, etc.) for each micro-partition. When a query includes a WHERE clause…
Question
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Options
- AB-tree
- BIndexing
- CMap reduce
- DPruning
How the community answered
(52 responses)- A2% (1)
- B2% (1)
- C8% (4)
- D88% (46)
Explanation
Snowflake uses a technique called micro-partition pruning (partition pruning) to avoid scanning irrelevant micro-partitions. Snowflake automatically stores metadata (min/max values, distinct value counts, etc.) for each micro-partition. When a query includes a WHERE clause filter, the query optimizer uses this metadata to prune (skip) micro-partitions that cannot contain matching rows, dramatically reducing I/O. Snowflake does not use traditional B-tree indexes or MapReduce.
Topics
Community Discussion
No community discussion yet for this question.