I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. Bookmark lookup or key lookup are bad for any query as they force query engine to lookpup corresponding row in the table or index as it does not find required data from just reading the data.
Here are list of my four post written on the same subject.
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
Let me know your opinion about the same and I am interested to here what you have to add to this subject.
Reference: Pinal Dave (https://blog.sqlauthority.com)
1 Comment. Leave new
Hi pinal , it was a great help , thanks