February 18, 2016 at 1:47 am
Hi,
While discussing with some of my friends about bookmark lookups, I found that Bookmark and key lookup (the lookup on clustered index ) are same , whereas RID lookup is a lookup on a Heap.
However while going though some sites and MSDN site, I found that a bookmark is like a pointer which can be Key lookup or RID lookup.
Still many articles and blog says bookmark lookup is key lookup.
This seems to be some confusion with the terminology.
Any comments ?
https://technet.microsoft.com/en-us/library/ms180920(v=sql.105).aspx
February 18, 2016 at 2:04 am
Bookmark lookup = SQL 2000 and before name. In 2005 and above it's called either a RID lookup or a key lookup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2016 at 2:22 am
Thanks Gail for the clarification but I guess even in Sql 2000 bookmark lookup refers to either key Or RID
Check this link:
https://technet.microsoft.com/en-us/library/aa178418(v=sql.80).aspx
February 18, 2016 at 2:27 am
er.mayankshukla (2/18/2016)
I guess even in Sql 2000 bookmark lookup refers to either key Or RID
Err, yes, that's what I just said.
What's called a bookmark lookup in SQL 2000 and before is called either a key or RID lookup in SQL 2005 and above.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2016 at 2:46 am
Thanks Gail,
My doubt is clarified
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply