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