I have a query that produces a good plan and a bad plan

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

avatar image By Erickson Winter 1 asked Oct 04 at 11:35 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

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.

Follow this question

Topics:

x631
x35
x2

asked: Oct 04 at 11:35 PM

Seen: 22 times

Last Updated: Oct 04 at 11:35 PM