Vince Vielhaber wrote:
>
> Now I've been wondering why my selects are so slow. Is this telling me
> that they're NOT using the index? And if not, any ideas why?
>
> The select returned 35 rows out of approx 170,000.
>
> -----
> campsites=> explain select * from locations where lower(city)='oxford';
^^^^^^^^^^^
You should
create index index_name on locations (lower(city))
^^^^^
- this is known as functional index...
> NOTICE: QUERY PLAN:
>
> Seq Scan on locations (cost=7263.30 size=84899 width=32)
Vadim