SQL SERVER Tutorials

The important difference between Clustered Index and Non Clustered Index in SQL Server

This article tells about the important difference between Clustered Index and Non Clustered Index in SQL Server.Please visit my other aricles to understand more about Clustered Index and Non Clustered Index in simple and easy way.

CLUSTERED INDEX
NON CLUSTERED INDEX
Clustered index is faster.
Non-clustered index is slower.
A table can have only one clustered index.
A table can have multiple non-clustered index.
A Clustered index is a type of index in which table records are physically reordered to match the index.
A Non-Clustered index is a special type of index in which logical order of index does not match physical stored order of the rows on disk.
Slower for insert and update operations.
Quicker for insert and update operations than a clustered index.