Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: I still believe CBO is better than RBO, but WTH?
"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