Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Are These 2 Stateents Identical
I need to change some vendor code for tuning purposes. I was hoping
that someone could verify that the 2nd statment is identical to the
first?
The 2nd runs much more quickly, but I just want to be safe.
DELETE
FROM CONTRACT
WHERE EXISTS ( SELECT 'X'
FROM CONTRACT_TEMP J WHERE J.CONTRACT_NUM = CONTRACT.CONTRACT_NUM AND J.CONTR_SEQ = CONTRACT.CONTR_SEQ AND J.CONTR_DT = CONTRACT.CONTR_DT AND J.CONTR_TYPE = CONTRACT.CONTR_TYPE );
DELETE
FROM CONTRACT
WHERE (CONTRACT.CONTRACT_NUM, CONTRACT.CONTR_SEQ, CONTRACT.CONTR_DT, CONTRACT.CONTR_TYPE ) IN ( SELECT J.CONTRACT_NUM,J.CONTR_SEQ,J.CONTR_DT,J.CONTR_TYPE FROM CONTRACT_TEMP J);Received on Tue Oct 23 2001 - 12:41:36 CDT