Post reply

Bookmark lookup

  • February 18, 2016 at 1:47 am

    #304802

    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

    #1859472

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 18, 2016 at 2:22 am

    #1859478

    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

    #1859481

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 18, 2016 at 2:46 am

    #1859485

    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