Skip to main content
Planned maintenance impacting Stack Overflow and all Stack Exchange sites is scheduled for Monday, September 16, 2024, 5:00 PM-10:00 PM EDT (Monday, September 16, 21:00 UTC- Tuesday, September 17, 2:00 UTC). The email/password authentication method will be unavailable for logging in and registering. Read more here

A type of index mostly used in SQL-Server, which aligns the data of a table with the index.

A CLUSTERED INDEX is used to organize an entire table in a specified order. The data pages in the clustered index are the pages of the table - the index itself contains all the data.

A helpful analogy is a phone book - the pages are in the order of LastName, Firstname but contain all the data about individual entries as well.

Similar concepts exist in other database systems, such as INDEX ORDERED TABLES in .