how to minimize the cost for key lookups

it take 60 mins to run and returns 21899 rows

Plan.pesession (317.4 kB)
avatar image By doutman 0 asked Apr 26 at 08:31 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first

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?

avatar image By Hugo Kornelis 271 answered Apr 27 at 08:13 PM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x683
x494
x1

asked: Apr 26 at 08:31 PM

Seen: 11 times

Last Updated: Apr 27 at 08:13 PM