David,
Yes, I do know that the Upper() would make a difference. In my case all three fields are key fields and entries are in upper case only.
I really don't know what the problem was (or if they really had a problem) but once I added two more fields to the WHERE expression, the time for the query went down considerably. A few minutes ago I talked to the customer and we timed it (while I was on the telephone), and it took 3 seconds.
So, I can rest this weekend <g> (I am kidding, of course, I never rest <g>).
>Dmitry,
>
>But you know it makes a difference if the index expression is upper(fieldname) right?
>
>If sys(3054) is reporting full then I suspect it's a network performance issue. Other things to look at are anti-virus software.
>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
