Clustered Indexes – Advantages & Disadvantages

Every time you create a Primary Key constraint in SQL Server, the constraint is (by default) enforced through a Unique Clustered Index. This means that you need to have in that column (or these columns, if you have defined a composite Primary Key) unique values. And as a side effect your table data is physically …

Clustered Indexes – Advantages & Disadvantages + read more