Without query hints or plan guides, is there a way to force the good plan? It appears to be the way the QO joins the tables (table 1 can join to both 2 and 3, or t1 can join to t2, which joins to t3)
Good plan is here: https://answers.sqlperformance.com/questions/4714/i-have-a-query-that-produces-a-good-plan-and-a-bad.html
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 x631
sql sentry upload x35
ax multiple plans x2
asked: Oct 04 at 11:35 PM
Seen: 22 times
Last Updated: Oct 04 at 11:35 PM
I have a query that produces a good plan and a bad plan
Sort Operation Performance
Why does changing an account name field change the execution plan so much?
Any idea why sp_MSdistribution_cleanup is so CPU intensive?
What should I look at to begin understanding the sudden performance degradation of this query?
Why does the Clustered Index Seek take 45% of plan?
Required Inputs on the Execution Plan
Microsoft GP 10 database table using longer time to get results
© 2013 SQL Sentry, Inc. All rights reserved.