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 x691
plan explorer upload x502
execution plan x125
poor performance x116
asked: Dec 11, 2014 at 10:06 PM
Seen: 146 times
Last Updated: Dec 12, 2014 at 07:39 PM
Execution plan mystery
Any ideas to increase performance of this query?
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
© 2013 SQL Sentry, Inc. All rights reserved.