Sample Header Ad - 728x90

Nasty Lookups in Query plan

1 vote
1 answer
133 views
I've been trying to get rid of expensive lookups in my query plan but cannot seem to get my head around it. I understand the idea of creating a covering index to eliminate the need for lookups but I don't know how to approach it with a complicated plan like this. Any ideas on how to approach this would really be appreciated. Query plan can be found here: https://www.brentozar.com/pastetheplan/?id=HyBbQ0eRr Thanks
Asked by Sicilian-Najdorf (381 rep)
Dec 13, 2019, 09:02 AM
Last activity: Dec 13, 2019, 10:50 AM