Before I write about the Index I just want to make clear the difference between the Primary key and index:
Primary key: It is not allowed duplicates
Index: It speeds up the performance of access.
DB2 List of Indexes
- Clustering index: It helps the way data physically stored in the database
- Unique index: This will be given normally with the primary key column. The value is unique.
- Partitioned Index: Index is located in partitioned datasets
- NPS: Non-partitioned secondary index
- DPSI: Data partitioned secondary index
- Single column index: Index on only one column
- Multi-column index: Index on multi-columns
Related Posts
Srinimf 