Re: Column order in indices (oracle 9.2)

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