PrepAway - Latest Free Exam Questions & Answers

What is an advantage of using range partitioned tables?

What is an advantage of using range partitioned tables?

PrepAway - Latest Free Exam Questions & Answers

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

Explanation:
https://www.ibm.com/developerworks/data/library/techarticle/dm-0605ahuja2/#query


Leave a Reply