Monday, May 16, 2016

Heaps - would it be faster than a table with a clustered index?

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: