Clustered vs non-clustered index — what is the difference?

Answer preview

A clustered index is the table: the rows themselves are stored in the index leaf pages in key order, so there can be only one per table. A non-clustered (secondary) index is a separate structure holding the key plus a pointer back to the row, so you can have many.…