You have anonymized the plan with an older version of Plan Explorer, which strips all statements to avoid revealing private information. Please generate a new plan with an updated version of Plan Explorer which can be downloaded here, or upload a new, non-anonymized version of the plan. This will provide additional details for analysis.
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
execution plan x121
poor performance x111
clustered index x24
asked: Jul 21, 2015 at 03:48 AM
Seen: 85 times
Last Updated: Jul 21, 2015 at 12:11 PM
How can I further optimise this query?
Execution plan mystery
How can I get an Index Seek on this PK CLUSTERED index?
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 ?
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 ?
A filter with the attached query causing slowness and performance issues
Trying to understand why partition elimination is happening in some plans, but not others
© 2013 SQL Sentry, Inc. All rights reserved.