Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Column order in indices (oracle 9.2) - solved (kind of)
According to Oracle the issue is a known bug 4901231 which is fixed in
oracle 9208 and oracle 10
I am currently upgrading this database to Oracle 10 and should be able to
confirm whether this is
the case.
Again, thanks to all who replied
thank you
Gene Gurevich
Oracle Engineering
224-405-4079
Wolfgang Breitling <breitliw_at_centrex To cc.com> genegurevich_at_discoverfinancial.com cc 08/01/2006 09:57 oracle-l <oracle-l_at_freelists.org> AM Subject Re: Column order in indices (oracle 9.2)
Is the partitioning based on the first(leading) column of the index? In my
experience - don't know if it's a fixed rule - a local partitioned index is
not
being used unless the partitioning column is among the predicates.
Having said that, I haven't had a chance to possibly revise that experience
with
Oracle 9.2 or 10.
Quoting genegurevich_at_discoverfinancial.com:
> Yechiel:
>
> The answers are yes and yes - the index is partitioned locally and I do
> have the histograms
>
> thank you
-- regards Wolfgang Breitling Oracle 7,8,8i,9i OCP DBA Centrex Consulting Corporation www.centrexcc.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 02 2006 - 08:10:34 CDT
![]() |
![]() |