WHAT IS A CLUSTERED INDEX?

Sumit Kesarwani

Total Post:782

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

    Post:782

    Points:3910
    What is a Clustered Index?

    The data rows are stored in order based on the clustered index key.

    Data stored is in a sequence of the index.

    In a clustered index, the physical order of the rows in the table is the same as the logical (indexed) order of the key values.

    A table can contain only one clustered index.

    A clustered index usually provides faster access to data than does a non-clustered index.

Answer

NEWSLETTER

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