Optimizing a like-cause

Поиск
Список
Период
Сортировка
От Stefan Sturm
Тема Optimizing a like-cause
Дата
Msg-id 26353992-BFEA-47A9-B73C-02F05B314211@gmail.com
обсуждение
Ответы Re: Optimizing a like-cause
Re: Optimizing a like-cause
Re: Optimizing a like-cause
Re: Optimizing a like-cause
Список pgsql-general
Hello,

I'm developing a autocomplete Feature using php and PostgreSQL 8.3.
To fill the autocomplete box I use the following SQL Statement:
select * from _table_ where upper( _field_ ) like '%STRING%';

This SQL Statement takes 900 ms on a Table with 300.000 entries.

What can I do to speed up the Statement? What Index can I set?

Thanks for your Help,
Stefan Sturm

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