SQL Server Quickie #18 – Bookmark Lookups

(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.)

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 Comments

  • Karthick

    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

    • 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

It`s your turn

Your email address will not be published. Required fields are marked *

SQLpassion

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top