Sample Header Ad - 728x90

Performance differences between RID Lookup vs Key Lookup?

4 votes
2 answers
7107 views
Are there any performance differences between when a non-clustered index uses the clustered index's key to locate the row vs when that table doesn't have a clustered index and the non-clustered index locates the row via the RID? Does different levels of fragmentation impact this performance comparison as well? (E.g. in both scenarios the tables are 0% fragmented, vs 50%, vs 100%.)
Asked by J.D. (40893 rep)
Sep 10, 2018, 06:30 PM
Last activity: Sep 11, 2018, 02:21 PM