Which statistics can be used to identify queries that have inefficient pruning? (Choose two.)
Which statistics can be used to identify queries that have inefficient pruning? (Choose two.)
To identify queries that have inefficient pruning, you should look at 'Partitions scanned' and 'Partitions total'. By comparing these two statistics, you can determine how much of the data was actually scanned versus the total available partitions. If the percentage of partitions scanned is high compared to the total partitions, it indicates inefficient pruning. Therefore, 'Partitions scanned' and 'Partitions total' are the correct statistics to use for identifying inefficient pruning.
https://select.dev/posts/snowflake-micro-partitions
"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." https://docs.snowflake.com/en/user-guide/ui-query-profile#inefficient-pruning
C & D is correct.