Is a RID Lookup faster than a Key Lookup?
Published On: May 10, 2016
Categories: T SQL, T SQL Tuesday, Disk Performance, Key Lookups 0
For T-SQL Tuesday #78, Aaron Bertrand (@AaronBertrand) takes a look at whether RID Lookups are faster than Key Lookups, with a small battery of fairly simple duration tests.
SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the "how" and the "why."