Practical T-SQL
Lesson 53. Why You Cannot Have More Than One Clustered Index On A Table
The technical reasons for this are irrelevant. Knowing the technical reason for this limitation will not allow you to put more than one clustered index on a table, so there is no reason to fill your brain with useless trivia.
What is really important is the philosophical reason for this limitation and that is this:
Every single table in your database should have a primary key.
I see tables without primary keys all the time, and each time I die a little inside.
Since the primary key is a clustered index and should have a primary key on all of your tables, ipso facto, you can’t have more than one clustered index on a table.
Copy link