What is a Clustered Index?
Ask by Sumit Kesarwani
Updated 21 Sep 2020
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.