Yechiel:
The answers are yes and yes - the index is partitioned locally and I do
have the histograms
thank you
Gene Gurevich
Yechiel Adar
<adar666@xxxxxxxx
t.il> To
Sent by: (names withheld)
oracle-l-bounce@f cc
reelists.org oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject
Re: Column order in indices (oracle
08/01/2006 09:52 9.2)
AM
Please respond to
adar666@xxxxxxxxx
.il
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
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
