Re: Re: LIKE and indexes?

3/15/2001 3:39:27 AM, Alexander Jerusalem <alexander.jerusalem@pop.chello.at>
wrote:

>Thanks for your answer, Alex!
>
>I've done an EXPLAIN and I saw that no index was used although my SQL
>statement had a wild card only at the end as you pointed out ('blah%'). My
>guess is that this is because of the locale support.

How large is the index in question?  I recall reading that PostgreSQL doesn't
utilize an index if the overhead of using it was calculated as higher than a
sequential scan.

Brent