Re: Tuning query

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:fm1H9.89423$g9.251125_at_newsfeeds.bigpond.com...
> Hi Niall,

<snip>
> As suggested by Billy and Rajxesh, I would take a close look at seeing if
> you can force the second plan to use the hash join (via hint) and at least
> get identical plans. If problem goes away, you know that was it.

See my reply to Rajxesh. Basically he and Billy were spot on. Now of course we have the minor matter of getting hinted SQL into a third party app with no direct control of the sql under standard edition. I have a cunning plan....

BTW congrats on the Ashes, hopefully sometime soon the old fogeys at the MCC will see sense (or die off) and allow the actual urn down under where it rightfully belongs. There was an interesting piece of analysis by ,I think, CMJ in the Times where he pointed out that actually Englands performances were improving over the last three Ashes series and that we should be in a position to win the trophy by the 2078 series :(.

G'Night

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************