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 |
- Re: [PERFORM] Using LIKE expression problem.. Michael Ryan S. Puncia
- Re: [PERFORM] Using LIKE expression problem.. Christopher Kings-Lynne
- Re: [PERFORM] Using LIKE expression probl... Michael Ryan S. Puncia
- Re: [PERFORM] Using LIKE expression p... Christopher Kings-Lynne
- Re: [PERFORM] Using LIKE expressi... Michael Ryan S. Puncia
- Re: [PERFORM] Using LIKE exp... Joseph Shraibman