This query used to run really fast (completed within seconds) but I think the execution plan has changed and now it runs over 5 minutes. I updated the statistics. What else should I do?
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 x664
plan explorer upload x474
asked: Sep 27, 2017 at 02:30 PM
Seen: 33 times
Last Updated: Sep 27, 2017 at 02:33 PM
Where do I begin?
Bulk Insert Query Performance Issue
How to improve performance
Help Optimizing View
Estimated way too less compared to Actual no of rows
Same Query, Two Plans, One Stinks
Could this query be more optimal?
Suggestions for improving performance of query
Optimise help required
The query is taking around 13 minutes to execute where prior it was just fraction of seconds.
© 2013 SQL Sentry, Inc. All rights reserved.