Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: Column order in indices (oracle 9.2)

From: "Derya Oktay" <deryaoktay@xxxxxxxxx>
To: genegurevich@xxxxxxxxxxxxxxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 1 Aug 2006 16:36:59 +0300

Hi
Using a hint may force to use your index. It may also give an idea if it is
really possible to use the provided index. Further, CBO runs on calculated
statistics be sure you work on correct statistic. The last but not least is,
Oracle may choose the way it use indexes according to table sizes.
Regards.
Derya.
On 8/1/06, genegurevich@xxxxxxxxxxxxxxxxxxxxx <
genegurevich@xxxxxxxxxxxxxxxxxxxxx> wrote:


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

Follow-Ups:

Re: Column order in indices (oracle 9.2)
From: genegurevich

References:
- Column order in indices (oracle 9.2)
  - From: genegurevich

Other related posts:

Column order in indices (oracle 9.2)

RE: Column order in indices (oracle 9.2)

Re: Column order in indices (oracle 9.2)

RE: Column order in indices (oracle 9.2)

Re: Column order in indices (oracle 9.2)

RE: Column order in indices (oracle 9.2)

Re: Column order in indices (oracle 9.2)