SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas
November 22, 2009 by pinaldave
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
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 3
SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes
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 (http://blog.sqlauthority.com)
Like this:
Like Loading...
Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology | 1 Comment
Leave a Reply
Hi pinal , it was a great help , thanks