COF-C02 · Question #320
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
The correct answer is C. Partitions scanned D. Partitions total. The statistics that can be used to identify queries with inefficient pruning are Partitions scanned' and Partitions total'. These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data…
Question
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
Options
- ABytes scanned
- BBytes written to result
- CPartitions scanned
- DPartitions total
- EPercentage scanned from cache
How the community answered
(25 responses)- A12% (3)
- C84% (21)
- E4% (1)
Explanation
The statistics that can be used to identify queries with inefficient pruning are Partitions scanned' and Partitions total'. These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning.
Topics
Community Discussion
No community discussion yet for this question.