On 7/19/06,
eagle fan <
eagle.f@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.5You should probably check there.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
