---
title: "What is cluster index?"  
description: "What is cluster index?"  
author: "Amit Singh"  
published: 2011-03-28  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/611/what-is-cluster-index  
category: "db2"  
tags: ["db2"]  
reading_time: 1 minute  

---

# What is cluster index?

For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently. \
\
Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index

## Answers

### Answer by Amit Singh

For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently. \
\
Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index


---

Original Source: https://www.mindstick.com/interview/611/what-is-cluster-index

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.