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.
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.