Answer-first summary for fast verification
Answer: Partitions scanned is less than partitions total.
Efficient pruning in Snowflake occurs when the query optimizer can eliminate unnecessary micro-partitions from being scanned, resulting in 'Partitions scanned' being significantly less than 'Partitions total'. This is explicitly stated in the Snowflake documentation referenced in the community discussion, which indicates that efficient pruning is demonstrated when 'Partitions scanned is less than partitions total'. The community discussion shows 100% consensus on option B, with multiple users citing the official documentation that confirms this interpretation. Options A, C, and D all describe scenarios where pruning is either inefficient or non-existent, as they involve scanning all or more partitions than necessary.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Based on the provided context, which of the following query results demonstrates that efficient pruning of micro-partitions has occurred?
A
Partitions scanned is greater than partitions total.
B
Partitions scanned is less than partitions total.
C
Partitions scanned is equal to the partitions total.
D
Partitions scanned is greater than or equal to the partitions total.
No comments yet.