The query takes a long time to run, looking for options to try and get it to run faster based on this plan?

LargeData_XML_ExecutionPlan_Anonymized.queryanalysis (122.6 kB)
avatar image By sap4ora 0 asked Jul 21, 2015 at 03:48 AM
more ▼
(comments are locked)
avatar image sdyckes Jul 21, 2015 at 12:11 PM

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.

10|10000 characters needed characters left
▼ Viewable by all users
0
0 answers: sort voted first ▼
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

We are Moving!

<p><br></p>

Follow this question

Topics:

x692
x503
x125
x116
x25

asked: Jul 21, 2015 at 03:48 AM

Seen: 119 times

Last Updated: Jul 21, 2015 at 12:11 PM

Related Questions

How can I further optimise this query?

Execution plan mystery

How can I get an Index Seek on this PK CLUSTERED index?

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 ?

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 ?

Performance Issues

A filter with the attached query causing slowness and performance issues