What is NON CLUSTERED INDEX in DB2? Explain with the help of practical example


The non-clustered index is just the opposite of the clustered index. In a non-clustered index, it is not necessary that the data rows having similar index keys should reside in the same page. This index is suitable if we have to traverse through the table.

For example, if we take the scenario where index keys of the table are the whole number - 2, 12, 14, etc. Then the non-clustered index structure would look like below−

Updated on: 14-Sep-2020

295 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements