Re: [SQL] making 'like' queries quicker - Mailing list pgsql-sql

From admin
Subject Re: [SQL] making 'like' queries quicker
Date
Msg-id Pine.BSF.4.10.9912181451230.11925-100000@server.b0x.com
Whole thread Raw
In response to Re: [SQL] making 'like' queries quicker  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: [SQL] making 'like' queries quicker
List pgsql-sql
Whatabout queries which only end with a wildcard? is there any way to
accelerate such a query?

> > Is there a way to make queries using the 'like' operator quicker, more
> > specifically for queries that look like:
> > select name from table where name like '%abc%';
> 
> These kinds of queries (where the search string starts with a wildcard)
> never use indexes, so you're stuck with the sequential scan. A faster
> computer is probably your best option. :(



pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [SQL] count() question
Next
From: "tjk@tksoft.com"
Date:
Subject: Re: [SQL] making 'like' queries quicker