Showplan Operator of the Week – BookMark/Key Lookup
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on 2010/05/25
Indexed on
2010/05/25
6:03 UTC
Read the original article
Hit count: 614
Filed under:
Fabiano continues in his mission to describe the major Showplan Operators used by SQL Server's Query Optimiser. This week he meets a star, the Key Lookup, a stalwart performer, but most famous for its role in ill-performing queries where an index does not 'cover' the data required to execute the query. If you understand why, and in what circumstances, key lookups are slow, it helps greatly with optimising query performance.
© SQL Server Central or respective owner