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:


The query that I'm trying to run (using only the second column in the
index) should bring about 30 rows out of 1bil


Other related posts: