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

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 19 Jul 2006 08:55:56 -0700
Message-ID: <bf46380607190855j33babdcay49a0aa5dc0eea0f2@mail.gmail.com>

On 7/19/06, eagle fan <eagle.f_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 19 2006 - 10:55:56 CDT