>    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. 



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to