Re: Column order in indices (oracle 9.2)

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Tue, 01 Aug 2006 16:52:05 +0200

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: