Indexing Deep Dive

Difficulty: Advanced

Question

What is the difference between a Clustered and a Non-Clustered index?

Answer

A **Clustered Index** determines the physical order of data in the table (one per table). A **Non-Clustered Index** is a separate structure with pointers to the data rows.

Concepts covered

B-Tree, Hash Index, Clustered Index, Non-clustered Index, Performance