>Now your original slow command was:
>
>SELECT A.* FROM Address A, Cons C ;
>>> WHERE C.CCust = "GREATLA2" ;
>>> AND (C.Addrnum = A.Addrnum OR C.PAddrnum = A.Addrnum)
>>>
>
>You say that C.Addrnum and C.PAddrnum are not indexed in CONS. That being the case, can you also try it reversing them in both sides of the OR... trying
>... AND (A.Addrnum = C.Addrnum OR A.Addrnum = C.PAddrnum) instead?
>

Makes no difference Jim, it's just a simple failure of the optimiser to recogize the potential here.