Difference between Cluster and Non-cluster index in SQL

clustered-index, indexing, non-clustered-index, sql

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.

Problem

Original source