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
Last activity: Dec 13, 2019, 10:50 AM