Home > DeveloperSection > Interviews > What is Non Clustered Index?

Posted on    June-15-2013 4:20 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1296  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    June-15-2013 12:00 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick