Dear All
I've search the archive and manuals and it says I should use C locale in order to enable LIKE to use index.
Postgresql was installed after I set the locale to C. So I'm sure the initdb will use C.
From EXPLAIN I know that :
SELECT * FROM GuestProfile WHERE FirstName LIKE 'a' will use index on FirstName
but
SELECT * FROM GuestProfile WHERE FirstName LIKE 'a%' will not use Index on FirstName
I have 9,999,999 records and it was VACUUM ANALYZE-d.
How do I enforce the optimizer to use the index ?
Thank you in advance
Andy