Home / DeveloperSection / Interviews / What is a Clustered Index?
You haven’t finished your post yet. Are you sure you want to leave and discard your draft?
Can you answer this question?
Sumit Kesarwani
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.
You have need login or register for voting of answers or question.
Sumit Kesarwani
27-Jan-2014The 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.