Re: Column order in indices (oracle 9.2)

Yechiel:

The answers are yes and yes - the index is partitioned locally and I do
have the histograms

thank you

Gene Gurevich



                                                                           
             Yechiel Adar                                                  
             <adar666@xxxxxxxx                                             
             t.il>                                                      To 
             Sent by:                  (names withheld)                    
             oracle-l-bounce@f                                          cc 
             reelists.org              oracle-l <oracle-l@xxxxxxxxxxxxx>   
                                                                   Subject 
                                       Re: Column order in indices (oracle 
             08/01/2006 09:52          9.2)                                
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             adar666@xxxxxxxxx                                             
                    .il                                                    
                                                                           
                                                                           




Does Oracle know that you have just 30 rows for this value, i.e. do you
have histograms?
Is the index partitioned?

Adar Yechiel
Rechovot, Israel



genegurevich@xxxxxxxxxxxxxxxxxxxxx wrote:

>Charles,
>
>The query that I'm trying to run (using only the second column in the
>index) should bring about 30 rows out of 1bil
>
>
>
--
http://www.freelists.org/webpage/oracle-l






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


Other related posts: