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.