Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Are These 2 Statements Equal?
I believe they are, but I would like another pair of eyes so I don't blow it
and get fired since I am changing vendor code. The performance of my
version (the 2nd) is far better than the first.
DELETE FROM t
WHERE TYPE IN (SELECT TYPE FROM x
WHERE process_date = :1 AND process_status = 'A') OR TYPE IN (SELECT TYPE FROM X2 WHERE process_date <=:2 AND process_status IN ('A','B'));
DELETE FROM t
WHERE TYPE IN (SELECT TYPE FROM x
WHERE process_date = :1 AND process_status = 'A' UNION SELECT TYPE FROM X2 WHERE process_date <=:2 AND process_status IN ('A','B'));Received on Tue Apr 01 2003 - 13:04:12 CST
![]() |
![]() |