Hmm, the estimates in the NO-OrderBy version are really bad too. I wonder why that is?
Could you supply the DDL for the tables with keys and indexes please? If there are a lot of unused columns, then you can just included the columns that are used in this query. Thanks.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]