SELECT A.* FROM Address A, Cons C ; > WHERE C.CCust = "GREATLA2" ; > AND C.PAddrnum = A.Addrnum ; >UNION SELECT A.* FROM Address A, Cons C ; > WHERE C.CCust = "GREATLA2" ; > AND C.Addrnum = A.Addrnum >>runs about 50 times faster than...
SELECT A.* FROM Address A, Cons C ; > WHERE C.CCust = "GREATLA2" ; > AND (C.Addrnum = A.Addrnum OR C.PAddrnum = A.Addrnum) >>Both queries show as fully optimized with SYS(3054,1), both return the same result set.