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)

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

1 answer: sort voted first
avatar image By Erickson Winter 1 answered Oct 04 at 11:36 PM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
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:34 PM

Seen: 31 times

Last Updated: Oct 04 at 11:36 PM