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_at_inter.ne                                             
             t.il>                                                      To 
             Sent by:                  (names withheld)                    
             oracle-l-bounce_at_f                                          cc 
             reelists.org              oracle-l <oracle-l_at_freelists.org>   
                                                                   Subject 
                                       Re: Column order in indices (oracle 
             08/01/2006 09:52          9.2)                                
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             adar666_at_inter.net                                             
                    .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_at_discoverfinancial.com 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