Andrus,
> SELECT toode, nimetus
> FROM toode
> WHERE toode ILIKE 'x10%' ESCAPE '!'
> ORDER BY UPPER(toode ),nimetus LIMIT 100
>
> runs 1 minute in first time for small table size.
>
> Toode field type is CHAR(20)
1) why are you using CHAR and not VARCHAR or TEXT? CHAR will give you
problems using an index, period.
2) You can't use an index on ILIKE. You can, however, use an index on
lower(field) if your query is properly phrased and if you've created an
expression index on lower(field).
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco