Should every table have a clustered index?
Score: 4.9/5 (48 votes) 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. ... With few exceptio...