On Tuesday 22 July 2008, Stefan Sturm <stefan.s.sturm@xxxxxxxxxxxxxx> wrote: > 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? No index can be used for that query (where it starts with %). -- Alan
