My topic is “MDC Performance – Customer Examples and Experiences“. It is session E03 – part of the DB2 for Linux, UNIX, and Windows “Cutting Edge” track.
For those unfamilar, MDC refers to Multidimensional Clustering. DB2’s MDC technology was developed by IBM Research and shipped with DB2 UDB v8.1. It is primarily intended for data warehousing and large database environments. However, customers are also using it in online transaction processing (OLTP) environments.
By changing the physical layout of data, MDC enables customers to automatically cluster their tables along multiple dimensions. The result is better performance and reduced maintenance.