The column order does matter, but Oracle can SKIP SCAN an index in the
situation you talk about. To determine exactly what is going on, you
should at least get an explain plan of your sql. I imagine there are
other factors involved.

-----Original Message-----
From: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org] On Behalf Of
genegurevich@discoverfinancial.com
Sent: Tuesday, August 01, 2006 7:44 AM
To: oracle-l
Subject: Column order in indices (oracle 9.2)

Hi everybody:

I remember reading that in Oracle 9.2 and higher the order of the
columns in an index does not matter.
That is oracle will be able to quickly search on a column even if it is
not a leading one. I have a table with a primary key consisting of three
columns. When a table is queried based on the third column, the data
start coming out immediately, but when I use the second column the query
just sits there.
Is that an expected behavior? Did I misunderstood something about the
column order?

thanks for any insight

Gene Gurevich


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


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