What is Non Clustered Index?
Ask by Sumit Kesarwani
Updated 21 Sep 2020
Non 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.