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

Posted on    January-27-2014 2:41 AM

 C# C# 
 1 Answer(s)
  1096  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    January-27-2014 1:00 AM

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.

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

Follow MindStick