Re: [SQL] How can I optimize a research on text field?

From: Mike Meyer <mwm(at)phone(dot)net>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] How can I optimize a research on text field?
Date: 1998-10-30 18:20:14
Message-ID: Pine.BSF.4.05.9810301017590.5269-100000@guru.phone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 30 Oct 1998, Jerome Knobl wrote:
> I tried btree and hash method, but when I make a clause like : where nom
> like '%PICASSO%'; the request don't use any index!?!

Check the FAQ, question 3.10 (or thereabouts). Text searches only use
the index if they are searching for text at the start of the field.

<mike

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message pgateau . 1998-10-30 19:08:42 sql libpq access to varchar column
Previous Message Jerome Knobl 1998-10-30 15:38:55 How can I optimize a research on text field?