SQL Server Interview Question #124
What is the difference between clustered and nonclustered indexes?
Indexes & Query Performance Senior Advanced
Detailed Explanation
A clustered index contains the table data at its leaf level and determines the table's clustered storage order. A nonclustered index is a separate structure containing index keys and a locator to the corresponding row.
A table can have only one clustered index but multiple nonclustered indexes. Neither type is universally faster; performance depends on the query, key order, selectivity, included columns, data distribution, and workload.