Using LIKE expression problem.. - Mailing list pgsql-performance

From Michael Ryan S. Puncia
Subject Using LIKE expression problem..
Date
Msg-id 200405120606.i4C65ph9000939@mail.census.gov.ph
Whole thread Raw
Responses Re: Using LIKE expression problem..  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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

pgsql-performance by date:

Previous
From: spied@yandex.ru
Date:
Subject: Re: Quad processor options
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Using LIKE expression problem..