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


Other related posts: