SQL Server – When to use Clustered vs non-Clustered Index?
I just want to put in a word of warning: please very carefully pick your clustered index! Every “regular” data table ought to have a clustered index, since having a clustered index does indeed speed up a lot of operations – yes, speed up, even inserts and deletes! But only if you pick a good … Read more