SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup


Earlier last week, I published a blog post and SQL in Sixty Seconds video and it got thousands of view in just a few hours and I have received lots of questions based on this question about how to remove bookmark lookup. I have taken the 7 most asked questions and decided to answer them over here.

7 Q and A on Remove Bookmark Lookup

Question 1: I see you adding STATISTICS IO ON on the top of the query, does it slow down your query execution.
Answer 1: Everything you add to query which is not essential to the query will add