Re: Column order in indices (oracle 9.2)

Derya,

I have tried a hint, but the explain plan did not change. The stats were created too. I have opened a SR with
oracle to see what they say

thank you

Gene Gurevich

                                                                           
             "Derya Oktay"                                                 
             <deryaoktay_at_gmail                                             
             .com>                                                      To 
                                       genegurevich_at_discoverfinancial.com, 
             08/01/2006 08:36          oracle-l <oracle-l_at_freelists.org>   
             AM                                                         cc 
                                                                           
                                                                   Subject 
                                       Re: Column order in indices (oracle 
                                       9.2)                                
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           

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_at_discoverfinancial.com < genegurevich_at_discoverfinancial.com> 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

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