Examice

Exam C2090-600 All QuestionsBrowse all questions from this exam

Go to Exam

Question 6

What is an advantage of using range partitioned tables?

Ability to run utilities against the partitions in parallel

Increased query performance through data partition elimination

Block indexes are much smaller than RID indexes, providing better performance

Table data is automatically and continuously clustered, requiring minimal reorganization

Correct Answer: B

Range partitioned tables can significantly improve query performance by enabling partition elimination. This allows the database to scan only the relevant partitions instead of the entire table when executing queries, thus reducing the amount of data scanned and improving efficiency.

Discussion

db2tester

See also reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.perf.doc/doc/c0021579.html

db2testerOption: B

The answer B is correct. The answer C applies only on the MDC Table (Multi-Dimensional Clustering). Block Indexes are created with one or several table's dimensions and will reference several data blocks (block=extents) of the table. Each block will group data by dimension. The answer D applies only on the RCT Table (Range Clustered Table). Indeed, its RID is computed by a key sequence (with one or several table's columns), the RCT table is clustered by default.