MDC Performance Guidelines
The following section will describe tips and techniques for understanding the performance characteristics of workloads using MDC tables that are different from regular table design choices. These performance aspects consist of the following:
Query processing and validating query plans
Choosing RID indexes to complement the dimension block indexes
Performance tuning parameters for queries, inserts, and load
Limitations and troubleshooting tips
Query Processing Overview
In general, the query workload should take advantage of the multi-dimensional clustering by using block indexes effectively. Block indexes can be used for index scans, index ANDing, index ORing, nested loop joins, star joins, hash joins, and group by clauses. ...
Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
