Summary
As you can see, MDC tables provide a unique and powerful solution for large database performance and high availability. MDC benefits include the following:
Extending the performance advantages of clustering to multiple dimensions.
Automatic and dynamic maintenance of clustering over time.
The need for reorganizations are reduced to space reclamation only.
Data organization provides benefits of partition elimination.
Block-based indexes provide additional high-performance access plans and block elimination in queries.
Block index size results in faster scans and reduced overhead for logging and maintenance.
A simple, flexible syntax makes it easy to set up and maintain.
Get DB2® Version 8: The Official Guide 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.
