Articles>



Performance Tuning

Clustered Vs. Non-Clustered Indexing
15 Feb 2007

At first understanding the differences between clustered and non-clustered indexing is quite confusing. 

A clustered index will reorder the way records are stored in the database.  Because of this tables can only have one clustered index.

A nonclustered index is a type of index in were the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Slan Dizier