I am building a query which uses a clause like "Where doc_description like
'%keyword%'". I know a normal index won't be of any use here, but since the
table in question will get fairly big, I do want to use an index.
Can anyone give me some advise on what kind of index I can use here? Or
shouldn't I use one in this case?
pgsql-performance by date
|Next:||From: Richard Huxton||Date: 2004-03-31 12:07:54|
|Subject: Re: What index for 'like (%keyword%)' ???|
|Previous:||From: Richard Huxton||Date: 2004-03-31 08:33:24|
|Subject: Re: select slow?|