---
title: "DB2: List of 7 Top Indexes"
description: "There are different indexes being used in DB2. The reasons are no always the same. The all 7 indexes explained for ready use."
url: https://srinimf.com/2010/07/24/db2-indexes/
date: 2010-07-24
modified: 2026-10-08
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2010/07/pexels-photo-4406222.jpeg?fit=1880%2C1253&ssl=1
categories: ["DB2"]
tags: ["DB2 Indexes", "DB2 Tips and Solutions"]
type: post
lang: en
---

# DB2: List of 7 Top Indexes

Before I write about the Index I just want to make clear the difference between the [Primary key](https://srinimf.com/2016/08/04/how-db2-primary-key-differ-from-other-rdbms-databases/) and index:

> Primary key: It is not allowed duplicatesIndex: It speeds up the performance of access.

## DB2 List of Indexes

1. **[Clustering index](https://srinimf.com/2018/11/01/db2-top-differences-read-on-index-vs-hashing/):** It helps the way data physically stored in the database
2. **[Unique index](https://srinimf.com/2015/08/09/db2-different-sql-queries-for-creating-index-1-of-2/)**: This will be given normally with the [primary key](https://srinimf.com/2015/08/18/db2-questions-on-primary-key-view-static-sql-and-dynamic-sql/) column. The value is unique.
3. **Partitioned Index: **Index is located in partitioned datasets
4. **NPS: **Non-partitioned [secondary index](https://srinimf.com/2016/10/10/how-many-secondary-indexes-can-have-in-sql-query/)
5. **DPSI:** Data partitioned [secondary index](https://srinimf.com/2016/10/04/the-best-way-to-delete-vsam-secondary-index/)
6. **Single column index**: Index on only one column
7. **Multi-column index**: Index on multi-columns

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2010%2F07%2F24%2Fdb2-indexes%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2010%2F07%2Fpexels-photo-4406222.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=DB2%3A%20List%20of%207%20Top%20Indexes)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2010/07/24/db2-indexes/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2010/07/24/db2-indexes/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2010/07/24/db2-indexes/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2010/07/24/db2-indexes/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%3A%20List%20of%207%20Top%20Indexes&body=https%3A%2F%2Fsrinimf.com%2F2010%2F07%2F24%2Fdb2-indexes%2F&share=email)
-

### Like this:

Like Loading…