Terminology Required to Understand MDC Tables
Before looking at how to use this technology and the details about what it is, it is important to understand the terminology used when discussing MDC tables. This section details the key terms that you will encounter throughout this chapter and briefly describes them. Details on each and their use follows in this chapter.
MDC Table
An MDC table is a table with data that is physically clustered on more than one table column (or dimension) simultaneously. It is created using the standard CREATE TABLE statement, using the ORGANIZE BY DIMENSIONS clause.
Dimension
A particular defined area of interest, specified at table creation time. An MDC dimension is a clustering key for a table. Data having particular ...
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.
