What is Non Clustered Index? Sumit Kesarwani234815-Jun-2013mssql servermssql server Updated on 21-Sep-2020
Sumit Kesarwani
15-Jun-2013Non Clustered index:
A non clustered index contains a bookmark to the table records in the leaf level.
If a clustered index exists on a table, a non clustered index uses it to facilitate data lookup.
We could create 249 non clustered indexes on a single table.