IBM
C2090-600 · Question #28
What is an advantage of using range partitioned tables?
The correct answer is B. Increased query performance through data partition elimination. See the full explanation below for the reasoning.
Question
What is an advantage of using range partitioned tables?
Options
- AAbility to run utilities against the partitions in parallel
- BIncreased query performance through data partition elimination
- CBlock indexes are much smaller than RID indexes, providing better performance
- DTable data is automatically and continuously clustered, requiring minimal reorganization
How the community answered
(22 responses)- A14% (3)
- B77% (17)
- C5% (1)
- D5% (1)
Community Discussion
No community discussion yet for this question.