Re: Using LIKE expression problem..

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>

To: "Michael Ryan S. Puncia" <mpuncia@census.gov.ph>

Cc: pgsql-performance@postgresql.org

Date: 2004-05-12T06:48:29Z

Lists: pgsql-performance

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

Have you run VACUUM ANALYZE; on the table recently?

Chris