I have a fairly large table with a char(20) field in it which I search on
quite a bit. The problem is that I tend to do a lot of
"...where field like '%-d%'" type searches on this field.
Is there any to speed up this type of search?
pgsql-performance by date
|Next:||From: SZUCS Gábor||Date: 2003-04-30 16:59:52|
|Subject: Re: Like search performance.|
|Previous:||From: Jean-Luc Lachance||Date: 2003-04-30 16:23:11|
|Subject: Re: Why LIMIT after scanning the table?|
pgsql-sql by date
|Next:||From: Martin Chantler||Date: 2003-04-30 16:52:00|
|Subject: Stored Procedure Question|
|Previous:||From: Josh Berkus||Date: 2003-04-30 16:03:38|
|Subject: Re: [SQL] 7.3 analyze & vacuum analyze problem|