Bookmark Lookups

  • This is a good article. I can see why it was reprinted. I'd like to see an update. Things are just a little different in 2005/2008. Those differences, some of them cosmetic, such as the change from bookmark lookup to RID lookup in the execution plans, would change some of the details of the article as well as some of the methods of correction (INCLUDE has been mentioned several times).

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Firstly , thank you for explaining Bookmark lookups with such clarity !

    I have the same question as SSC-Enthusiastic , how many covering index can we really afford to create ?

  • Hi Markus ,

    Could you give us some pointers beyond this article since you

    mentioned that you've just dealt with the same at a large scale

    Thanks !

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply