Daniel J. Summers wrote: > Tony Liao wrote: >> I try to explain analyze,but it doesn't work ,it use seq scan. > Generally speaking, LIKE doesn't use indexes. ?! That's not true at all!! -- Andrzej Zawadzki -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin