Which result shows efficient pruning?
Which result shows efficient pruning?
Efficient pruning is achieved when the number of partitions scanned is less than the total number of partitions available. This indicates that the system effectively pruned unnecessary partitions, thereby optimizing performance by reducing the amount of data that needs to be processed.
B https://docs.snowflake.com/en/user-guide/ui-query-profile.html#inefficient-pruning
Answer Should be B (scanned partitions should be less than total partitions)
B-https://docs.snowflake.com/en/user-guide/ui-query-profile.html#inefficient-pruning
https://docs.snowflake.com/en/user-guide/ui-query-profile#inefficient-pruning ... The efficiency of pruning can be observed by comparing Partitions scanned and Partitions total statistics in the TableScan operators. If the former is a small fraction of the latter, pruning is efficient. If not, the pruning did not have an effect. ...
correct
for sure B. thats the primary purpose of pruning... to scan less partitions
B is correct
B - correct