how to minimize the cost for key lookups

doutman 2018-04-26 20:31:30

it take 60 mins to run and returns 21899 rows

Hugo Kornelis 2018-04-27 20:13:59
I noticed that you posted two questions. This one includes an estimated plan only. The other one includes a (much more useful) actual execution plan for what appears to be the same query.

I will respond to your other question. Maybe an admin can delete this one?