In design, we almost always automatically setup a clustered index. But should we?
The site SQLPerformance decided to take the challenge and find out if there are times when a heap just might be faster than a table with a clustered index. You can find all the details here: Is a RID Lookup faster than a Key Lookup? [SQL Performance].
No comments:
Post a Comment