I have UTF-8 Postgres 8.1 database on W2K3
SELECT toode, nimetus
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)
How to create index on toode field so that query can use it ?
pgsql-performance by date
|Next:||From: Andrew Sullivan||Date: 2006-06-05 19:42:52|
|Subject: Re: Some queries starting to hang|
|Previous:||From: Chris Beecroft||Date: 2006-06-05 19:05:08|
|Subject: Some queries starting to hang|