What is a Clustered Index?
2287
27-Jan-2014
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.