1 Reply Latest reply on Aug 21, 2013 1:25 PM by thatJeffSmith-Oracle

    what's wrong with this update statement(taking much time)

    supersen


      HI guys,

       

      following update statement takes much time to process.  Can anyone come across this simple update statmenet and comback with any suggestions at first

       

      UPDATE CONSUMER CS

      SET CS.CONSUMER_ID= ( SELECT CONSUMER_ID FROM STG_CONSUMER STG

      WHERE STG.VALUEID=CS.VALUEID)

      WHERE CS.VALUE_CODE IN ('58')

      AND EXISTS

      (SELECT STG.VALUEID

      FROM STG_CONSUMER STG

      WHERE STG.VALUEID=CS.VALUEID

      AND CS.VALUE_CODE IN ('58')

      );

       

      Please comeout without suggestions

       

      S