Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I still believe CBO is better than RBO, but WTH?

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

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 7 Sep 2001 07:21:25 +1000
Message-ID: <3b97e7da$1@news.iprimus.com.au>


"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message

0[huge snip]

> How did I fix this? Picked up the index ZOT_I1 and re-created it with
> the columns in the order of precedence of the data in the predicates
> above. Shouldn't make the slightest difference, because without stats
> I was getting good performance with EXACTLY the same index. With the
> new index, I get the same performance with or without stats.
>
> And they wonder why my hair is going white...
> <groan>
>

At least it's not falling out.

Anyway... why not use stored outlines? The benefits (cough!) of the cost-based optimizer with the predictability of rule-based.

Regards
HJR
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Thu Sep 06 2001 - 16:21:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US