>>Tore
>>
>>Further to my last reply to this message, I've now tried the following, with NO improvement. This is totally baffling me that something can be so slow. Weird thing is I got it to go really fast on Friday then it reverted to impossibly slow again, and I can't see what changed in between.
>
>Perhaps you want to try the following. In principle, a condition like:
>
>
>...WHERE Field1 + Field2 + Field3 = Value1 + Value2 + Value3
>
>
>can be faster than a condition on:
>
>
>... WHERE Field1 = Value1 AND Field2 = Value2 AND Field3 = Value3
>
>
>... assuming you have al requried indices. In the first case, you would need a compound index with the expression
Field1 + Field2 + Field3.
Two minds, one thought. That's why I asked Terry for the index expression.