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.
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 220.127.116.11
You should probably check there.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist