|
[oracle-l]
||
[Date Prev]
[08-2006 Date Index]
[Date Next]
||
[Thread Prev]
[08-2006 Thread Index]
[Thread Next]
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
|
