interview

home / developersection / interviews / what is cluster index?

Ask Question

What is cluster index?

Amit Singh 2316 28-Mar-2011
db2 db2 
Updated on 23-Sep-2020
Amit Singh

Other

Message
Can you answer this question?
Answer

1 Answers

Amit Singh

Amit Singh

28-Mar-2011
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
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy