SQL: How do I choose a clustering key in SQL Server?

added by DotNetKicks
1/7/2019 12:52:27 PM

1 Kicks, 472 Views

Clustered indexes vs heaps OK so you know that a table can have either be a heap or it can have a clustered index. The first question of course, is which should I use? If you have any doubt at all, put a clustered index on the table.