Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows®

MDC Indexes

When an MDC table is created, DB2 will automatically create the block dimension and regular dimension indexes, if needed.

NOTE

In the initial release of DB2 Version 8, the index is being created in the reverse order from what is described in the documentation, when there are composite dimensions. It is important to note that this will change in FixPack 1.

The following examples will show the current index definition, as well as how the index will be defined once FixPack 1 is installed. It is also important to note that existing block indexes will not be dropped and recreated when FixPack 1 is installed.

					create table city(name char(30), zipcode char(10), state char(2)) organize by (state)
				

The relevant information from the SYSCAT.INDEXES ...