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, The Team Membership, Mastering Index Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.