Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Are These 2 Stateents Identical

Are These 2 Stateents Identical

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: 23 Oct 2001 10:41:36 -0700
Message-ID: <f98999c8.0110230941.3033cb43@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US