DB2: List of 7 Top Indexes

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

  1. Clustering index: It helps the way data physically stored in the database
  2. Unique index: This will be given normally with the primary key column. The value is unique.
  3. Partitioned Index: Index is located in partitioned datasets
  4. NPS: Non-partitioned secondary index
  5. DPSI: Data partitioned secondary index
  6. Single column index: Index on only one column
  7. Multi-column index: Index on multi-columns

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.