Re: I still believe CBO is better than RBO, but WTH?

From: Buck Turgidson <noway_at_nohow.com>
Date: Sat, 08 Sep 2001 10:23:52 GMT
Message-ID: <Ykmm7.250888$J37.65208820@typhoon.southeast.rr.com>

I've been pulling my hair out with PeopleSoft (HR) SQL statement tuning for years. I often see Rule run better, in fact we run our instance in Rule, with some Choose hints placed on some on-line search views.

The SQL in PeopleSoft 8 is horrendously bad.

"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3b98af44.5074480_at_news...
> On Fri, 7 Sep 2001 07:21:25 +1000, "Howard J. Rogers"
> <howardjr_at_www.com> wrote:
>
> >At least it's not falling out.
>
> Says you.... ;-)
>
> >
> >Anyway... why not use stored outlines? The benefits (cough!) of
the
> >cost-based optimizer with the predictability of rule-based.
> >
>
> Seriously looking into that now.
>
> I'm getting utterly fed-up with the constant easter-eggs in the CBO.
> RBO was dumb as an ass, but at least it was *predictable*.
>
> This crap they call the CBO isn't. Completely random performance
> expectation is just not on.
>
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Sat Sep 08 2001 - 05:23:52 CDT