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

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: (view raw, whole thread or download thread mbox)
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 uses seq scan rather than index scan .. why ? I have
index on lastname, firtname. 





pgsql-performance by date

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

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