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