WHAT IS NON CLUSTERED INDEX?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1473  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is Non Clustered Index?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!