It took like 2 hour to perform this SP can somebody help me to find out why
You're using nested cursors.
Thanks for the help Any Suggestions in order to improve the performance?
It's hard to say much based on an estimated anonymized plan, aside from to recode the logic to not use nested cursors.
Thank again I will upload the non anonymized plan might you can help me with that...
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 x670
plan explorer upload x480
execution plan x123
poor performance x112
asked: Dec 11, 2014 at 10:06 PM
Seen: 135 times
Last Updated: Dec 12, 2014 at 07:39 PM
Execution plan mystery
Same Query, Two Plans, One Stinks
How can I improve this plan. Table Insert is costing the most at 84.6% - can it be improved ?
A filter with the attached query causing slowness and performance issues
Slow query - I think my index is just making things worse :(
Any idea why the filter limiting to 5K instead of 320K rows is done at the end ?
The query takes a long time to run, looking for options to try and get it to run faster based on this plan?
Trying to understand why partition elimination is happening in some plans, but not others
The SSRS report wont show up in sql server 2005
© 2013 SQL Sentry, Inc. All rights reserved.