Re: Ok, why isn't it using *this* index?

Paul Tomblin wrote:

> I have a table with columns 'country' and 'state'.  I put indexes on both
> of them.  I've done the "vacuum analyze" as per the faq.  But when I ask
> it to explain, it says it will use the index on 'state' if I do a
>     select * from waypoint where state = 'ON';
> but it won't use the index on 'country' if I do a
>     select * from waypoint where country = 'CANADA';
>
> Some other interesting things are that it uses the index on state even if
> I say "where state in ('ON','QC','BC','AB')", and it uses the index on
> state but not the one on country if I combine "where state = 'ON' and
> country = 'CANADA'".

    Maybe it's just my Oracle side, but doesn't country has a too low
selectivity?



--
  _
/ \   Leandro Guimarães Faria Corsetti Dutra         +55 (11) 3040 8913
\ /   Amdocs at Bell Canada                          +1 (514) 786 87 47
  X    Support Center, São Paulo, Brazil          mailto:adbaamd@bell.ca
/ \   http://terravista.pt./Enseada/1989/    mailto:leandrod@amdocs.com