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, 2017 at 03:07 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Nov 30, 2017 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



asked: Nov 27, 2017 at 03:07 PM

Seen: 34 times

Last Updated: Nov 30, 2017 at 05:46 PM