takes 28 seconds to run to produce 299 rows

gmdatdev 2017-11-27 15:07:33

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

Aaron Bertrand 2017-11-30 17:46:31
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.