Answer: Partitions scanned, Partitions total

The question asks for statistics that identify inefficient pruning, which occurs when a query scans more partitions than necessary. The community discussion consistently identifies C (Partitions scanned) and D (Partitions total) as the correct answers, with 100% consensus. Comparing these two metrics reveals pruning efficiency: if Partitions scanned is a small fraction of Partitions total, pruning is efficient; if they are similar, pruning is inefficient. Other options are less suitable: A (Bytes scanned) and B (Bytes written to result) relate to data volume but not partition-level pruning, and E (Percentage scanned from cache) concerns cache usage, not pruning effectiveness.

Author: LeetQuiz Editorial Team