sqlindexingclustered-indexnon-clustered-index

Difference between Cluster and Non-cluster index in SQL

Just for knowledge in interview question, and my knowledge.

SQL - Difference between Cluster and Non-cluster index?

Solution

  • A link describing the two.

    http://www.mssqlcity.com/FAQ/General/clustered_vs_nonclustered_indexes.htm

    http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx

    The difference is in the physical order of the records in the table relative to the index. A clustered index is physically ordered that way in the table.