2.2 Tuning to Avoid Key Lookups and Residual Predicates

sp_BlitzCache’s warning about Expensive Key Lookups has a few different possible solutions: Look for predicates on the lookup for surefire things to add to the nonclustered index Look for output fields to consider, but maybe not add Or just live with the key lookups when they’re big fields, or not a lot of rows Brent…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM or Mastering Index Tuning, or log in if you already shelled out the cash.

sp_BlitzCache’s warning about Expensive Key Lookups has a few different possible solutions: Look for predicates on the lookup for surefire things to add to the nonclustered index Look for output fields to consider, but maybe not add Or just live with the key lookups when they’re big fields, or not a lot of rows Brent...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM or Mastering Index Tuning, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}