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
Join MindStick Community
You need to log in or register to vote on answers or questions.
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.
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