What is a clustered index vs non-clustered index?

Clustered index determines physical row order; non-clustered is a separate structure.

A clustered index sorts and stores table data based on key values, meaning the table itself is the index. A non-clustered index is a separate structure that points to data rows. Clustered indexes are ideal for range queries; non-clustered indexes are better for lookups.