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

DB2DatabaseBig Data Analytics

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−

Published on 14-Sep-2020 10:47:14