> 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