You can create an index to optimize queries for end users of the warehouse. An index is a set of keys, each pointing to a set of rows in a table. The index is a separate object from the table data. The database manager builds the index structure and maintains it automatically. An index gives more efficient access to rows in a table by creating a direct path to the data through the pointers that it creates.
An index is created when you define a primary key or a foreign key. For example, an index was created on the LOOKUP_MARKET table when you defined CITY_ID as its primary key in Lesson 11, Defining keys on target tables.
To create additional indexes:
The Connect window opens.
The Index wizard opens.
For more information about creating an index, see the DB2 Universal Database Administration Guide.