Clustered Index

The index that decides the order rows are stored in; one per table.

What is Clustered Index?

A clustered index decides the order the table's rows are physically stored in. A table can have only one; by default it is the primary key.

CREATE CLUSTERED INDEX IX_Orders_PlacedAt ON dbo.Orders (PlacedAt);

Level: Journeyman · More Database terms at this level

Updated September 27, 2026