SQL Server Quickie #18 – Bookmark Lookups

Today I have uploaded the 18th SQL Server Quickie to YouTube. This time I’m talking about Bookmark Lookups in SQL Server.

Like or share to get the source code.

Thanks for watching!

-Klaus

2 thoughts on “SQL Server Quickie #18 – Bookmark Lookups”

Karthick
10/06/2014 at 5:44 PM

Thanks for the post and it was very helpful, I have quick question what happened if we need to add 10-20 columns in the select query do we need to include all the columns in the Include ? Thanks Karthick

Reply
1. Klaus Aschenbrenner
  10/13/2014 at 5:44 PM
  
  Hello,
  
  Thanks for your comment.
  Technically you can include these columns, but practically it doesn’t make sense, because you duplicate all these columns in the Non-Clustered Index.
  So you have to check your requirements, if you need all these columns in your application, and otherwise you have to live with the Bookmark Lookup.
  
  Thanks,
  
  -Klaus
  
  Reply

Leave a Comment Cancel Reply

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.