We have a update on temp table which is running very slow on ver 7.2 .Here is the query. Is there anywat we can rewrite it to run faster?
UPDATE SESSION.TEMP_AMOUNT02 TMP_AMT
SET (
CLM_VAL
) =
(
SELECT TMP_CVL.CLM_VAL
FROM SESSION.TEMP_CLMVAL TMP_CVL
WHERE TMP_AMT.CLM_CVRG_ID = TMP_CVL.CLM_CVRG_ID
AND TMP_AMT.CLM_NUM = TMP_CVL.CLM_NUM
);
UPDATE SESSION.TEMP_AMOUNT02 TMP_AMT
SET (
CLM_VAL
) =
(
SELECT TMP_CVL.CLM_VAL
FROM SESSION.TEMP_CLMVAL TMP_CVL
WHERE TMP_AMT.CLM_CVRG_ID = TMP_CVL.CLM_CVRG_ID
AND TMP_AMT.CLM_NUM = TMP_CVL.CLM_NUM
);