Quoting ADBAAMD ([EMAIL PROTECTED]):
> 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';
>
> Maybe it's just my Oracle side, but doesn't country has a too low
> selectivity?
If I try
explain select * from waypoint where country = 'BELIZE';
a query that will only select one record out of the 8300-odd, it still
doesn't use the index.
Seq Scan on waypoint (cost=455.13 rows=6813 width=130)
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
Mommy, what does "Formatting Drive C:" mean?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
