>>> "Greg Caulton" <[EMAIL PROTECTED]> wrote: > but I get a sequential scan when I do where term_index like > > select * from sct_descriptions where term_index like 'CHILLS AND FEVER > (FINDING)' > Is there anything else I can do? Settings below, this is PostgreSQL 8.3 > "lc_collate";"English_United States.1252" > "lc_ctype";"English_United States.1252" > "lc_messages";"English_United States" > "lc_monetary";"English_United States" > "lc_numeric";"English_United States" > "lc_time";"English_United States" This issue is discussed here: http://www.postgresql.org/docs/8.2/interactive/locale.html with a solution to your specific problem mentioned here: http://www.postgresql.org/docs/8.2/interactive/indexes-opclass.html You can create an index with the appropriate operator type to get LIKE to work as you want. I hope this helps. -Kevin
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
