Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
To determine if efficient pruning is occurring, it is essential to analyze the statistics related to partitions. Specifically, comparing the 'Partitions total' and 'Partitions scanned' can provide insight into the pruning efficiency. If the number of partitions scanned is a small fraction of the total partitions, it indicates effective pruning, as fewer partitions are processed, reducing the workload and resource usage.
https://docs.snowflake.com/en/user-guide/ui-query-profile.html#inefficient-pruning
https://docs.snowflake.com/en/user-guide/ui-query-profile.html#inefficient-pruning
C and E are correct, Because, that higher the ratio of existing partitions is to the scanned, that better (more efficient)=
CE are correct
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