Using LIKE expression problem..

From: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Using LIKE expression problem..
Date: 2004-05-12 06:18:48
Message-ID: 200405120606.i4C65ph9000939@mail.census.gov.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi everybody..

Before anything else I would like to thank all those person who answers
my previous question. again thank you very much

This is my question .

In my query .. Select * from table1 where lastname LIKE 'PUNCIA%'..

In the query plan ..it uses seq scan rather than index scan .. why ? I have
index on lastname, firtname.

Thanks

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-05-12 06:48:29 Re: Using LIKE expression problem..
Previous Message spied 2004-05-12 05:34:34 Re: Quad processor options