Re: Why CBO doesn't choose the low cost plan

On 7/19/06, eagle fan <eagle.f@xxxxxxxxx> wrote: 

hi:

My oracle version is 9205 and optimizer_features_enable is set to 9.2.0.

We have a query choose a bad plan.

...
What do you think?



I think it's a bug.

Check MetaLink.

A possible candidate is *Bug 4112254 - CBO may not choose best index for
single table access with unpeeked bind/function*

I just searched MetaLink on CBO Bug 9.2.0.5

You should probably check there.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: