Re: How to use index in case insensitive substing search

["Andrus" <eetasoft@xxxxxxxxx>]

>    do you have an index on klient (lower(nimi))?

Yes. As I wrote in first message, I created index explicity for this test 
sample:

create index nimib2 on firma1.klient(lower(nimi) bpchar_pattern_ops);

Andrus.