takes 28 seconds to run to produce 299 rows

millions of rows generated in hash operator, how to avoid this

Plan.pesession (158.3 kB)
avatar image By gmdatdev 0 asked Nov 27 at 03:07 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Nov 30 at 05:46 PM

Can you provide the definition of the view? I can see which tables are involved from the join diagram tab, but I can't see what else the query in the view might be doing to produce the problematic merge join with 17 million rows of output.

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
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:

x650
x37
x1
x1

asked: Nov 27 at 03:07 PM

Seen: 21 times

Last Updated: Nov 30 at 05:46 PM