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.
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.