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.
pgsql-performance by date
|Next:||From: Christopher Kings-Lynne||Date: 2004-05-12 06:48:29|
|Subject: Re: Using LIKE expression problem..|
|Previous:||From: spied||Date: 2004-05-12 05:34:34|
|Subject: Re: Quad processor options|