Re: Column order in indices (oracle 9.2)

From: <genegurevich_at_discoverfinancial.com>
Date: Tue, 1 Aug 2006 11:08:41 -0500
Message-ID: <OF984541B1.3053F9C7-ON862571BD.00588FEA-862571BD.0058AEA1@discoverfinancial.com>

Wolfgang,

This could explain my situation.
The table is partitioned on the column which is the first column in the Primary key, but it is not part of the where clause

thank you

Gene Gurevich

                                                                           
             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-l

Received on Tue Aug 01 2006 - 11:08:41 CDT