RFLM101@aol.com writes:
> When I issue a select* from table where column = part,
> query speed is great, however, changing the where clause to "where column
> like 'part%'" the explain analyze shows the database doing a full table scan
> and not utilzing the index which slows the query speed.
Unless you're in the "C" locale, LIKE queries currently won't use an
index. This is apparently not easy to fix--if you search the list
archives you'll find some discussions on it.
-Doug
