SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup
Posted
by pinaldave
on SQL Authority
See other posts from SQL Authority
or by pinaldave
Published on Thu, 13 May 2010 01:30:05 +0000
Indexed on
2010/05/13
1:35 UTC
Read the original article
Hit count: 1672
Pinal Dave
|sql
|SQL Authority
|SQL Backup and Restore
|SQL Index
|SQL Optimization
|SQL Performance
|SQL Query
|SQL Scripts
|SQL Server
|SQL Tips and Tricks
|SQLAuthority News
|SQLServer
|T SQL
|Technology
In recent times I have observed that not many people have proper understanding of what is bookmark lookup or key lookup. Increasing numbers of the questions tells me that this is something developers are encountering every single day but have no idea how to deal with it. I have previously written three articles on this subject. I want to point all of you looking for further information on the same post.
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries
In one of my recent class we had in depth conversation about what are the alternative of creating covering indexes to remove the bookmark lookup. I really want to this question open to all of you and see what community thinks about the same. Is there any other way then creating covering index or included index to remove his expensive keylookup?
Reference: Pinal Dave (http://blog.sqlauthority.com)
Filed under: Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology
© SQL Authority or respective owner
