3/15/2001 3:39:27 AM, Alexander Jerusalem <alexander(dot)jerusalem(at)pop(dot)chello(dot)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