MS SQL Server Indexes Interview Question:

Tell me the difference between clustered and non-clustered index?

Submitted by: Administrator

A clustered index reorders the way records are stored. A non clustered index is in which the logical order of the index does not match the physical stored order of the rows on disk. A clustered index is must faster because the index entries are actually data records. There can be just one clustered index per table while there can be up to 249 non clustered indexes
Submitted by: Administrator