Should every User Table have a Clustered Index?
It’s hard to state this more succinctly than SQL Server MVP Brad McGehee: As a rule of thumb, every table should have a clustered index. Generally, but not always, the clustered index should be on a column that monotonically increases–such as an identity column, or some other column where the value is increasing–and is unique. … Read more