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 CS.VALUE_CODE IN ('58')
FROM STG_CONSUMER STG
AND CS.VALUE_CODE IN ('58')
Please comeout without suggestions
This forum is 'not for general SQL/PLSQL questions' which is exactly what your question is.