millions of rows generated in hash operator, how to avoid this
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.
Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.
Answers and Comments
query plan x650
sql sentry upload x37
data islands x1
asked: Nov 27 at 03:07 PM
Seen: 21 times
Last Updated: Nov 30 at 05:46 PM
Sort Operation Performance
Why does changing an account name field change the execution plan so much?
Any idea why sp_MSdistribution_cleanup is so CPU intensive?
What should I look at to begin understanding the sudden performance degradation of this query?
Why does the Clustered Index Seek take 45% of plan?
Required Inputs on the Execution Plan
Having problems understanding what what can be improved
Microsoft GP 10 database table using longer time to get results
© 2013 SQL Sentry, Inc. All rights reserved.