Skip site navigation (1) Skip section navigation (2)

What index for 'like (%keyword%)' ???

From: "Priem, Alexander" <ap(at)cict(dot)nl>
To: pgsql-performance(at)postgresql(dot)org
Subject: What index for 'like (%keyword%)' ???
Date: 2004-03-31 09:51:02
Message-ID: 2A07EC2D0BC2774AAD6F74769F60D52A08329A@ahmose.cict_ad.nl (view raw or flat)
Thread:
Lists: pgsql-performance
Hi everyone,

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?

Kind regards,
Alexander Priem.

Responses

pgsql-performance by date

Next:From: Richard HuxtonDate: 2004-03-31 12:07:54
Subject: Re: What index for 'like (%keyword%)' ???
Previous:From: Richard HuxtonDate: 2004-03-31 08:33:24
Subject: Re: select slow?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group