DB2 10 for z/OS Database Administrator — Question 17

What is an advantage of using range partitioned tables?

Answer options

• A. Ability to run utilities against the partitions in parallel
• B. Increased query performance through data partition elimination
• C. Block indexes are much smaller than RID indexes, providing better performance
• D. Table data is automatically and continuously clustered, requiring minimal reorganization

Correct answer: B

Explanation

The correct answer, B, highlights how range partitioned tables can improve query performance by eliminating unnecessary data scans. Options A, C, and D may present benefits related to partitioning or indexing, but they do not specifically address the performance improvements gained through data partition elimination.