How to boost performance of ilike queries ?

Поиск
Список
Период
Сортировка
От Antony Paul
Тема How to boost performance of ilike queries ?
Дата
Msg-id 2989532e05012401184b0c3ef9@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to boost performance of ilike queries ?  (Russell Smith <mr-russ@pws.com.au>)
Список pgsql-performance
Дерево обсуждения 
Hi,
    I have a query which is executed using ilike. The query values are
received from user and it is executed using PreparedStatement.
Currently all queries are executed as it is using iilike irrespective
of whether it have a pattern matching character or not. Can using =
instead of ilike boot performance ?.  If creating index can help then
how the index should be created on lower case or uppercase ?.

rgds
Antony Paul

В списке pgsql-performance по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Faster and more frequent VACUUM (was PostgreSQL clustering VS MySQL clustering)
Следующее
От: Andrei Reinus
Дата:
Сообщение: Re: poor performance of db?