Does Oracle know that you have just 30 rows for this value, i.e. do you
Is the index partitioned?
Adar Yechiel Rechovot, Israel
The query that I'm trying to run (using only the second column in the index) should bring about 30 rows out of 1bil