UPDATE F_ATTRIBUTES_PROCESSING FP SET TAC_003 = ( SELECT T.TAC_003 FROM
(SELECT /*+ PARALLEL (D_ACCOUNT,8) */ D_ACCOUNT.ACCOUNT_NO,
WHEN T1.ACCOUNT_NO IS NULL AND D_ACCOUNT.STATUS !=10103
WHEN D_ACCOUNT.STATUS = 10103
(SELECT /*+ PARALLEL ( D_BILLINFO,8) */ D_BILLINFO.ACCOUNT_NO, D_BILLINFO.PAY_TYPE, D_BILLINFO.LAST_BILL_T, D_BILLINFO.NEXT_BILL_T FROM D_BILLINFO
WHERE D_BILLINFO.PAY_TYPE = 10200 AND ((SYSDATE - D_BILLINFO.LAST_BILL_T) <= 17 OR (D_BILLINFO.NEXT_BILL_T - SYSDATE)<=5)) T1
WHERE D_ACCOUNT.ACCOUNT_NO = T1.ACCOUNT_NO (+)) T WHERE FP.BILL_ACCNT_KEY = T.ACCOUNT_NO);
UPDATE F_ATTRIBUTES_PROCESSING FP SET TAC_007 = ( SELECT T.TAC_007 FROM
(SELECT /*+ PARALLEL ( D_ACCOUNT,8) */ D_ACCOUNT.ACCOUNT_NO,
WHEN T1.MORGANE_ACCOUNT_NUMBER IS NULL
FROM D_ACCOUNT ,
(SELECT /*+ PARALLEL (TRIBE_ORDER,8) PARALLEL (D_MEMBER,8) */ DISTINCT D_MEMBER.MORGANE_ACCOUNT_NUMBER FROM D_ORDER TRIBE_ORDER, D_MEMBER
WHERE D_MEMBER.MS_MMD_ACCOUNTNUMBER_FK = TRIBE_ORDER.MMD_ACCOUNTNUMBER AND D_MEMBER.MS_SP_SYSTEMCODE_FK = 2 AND TRIBE_ORDER.OTY_ORDER_SUBTYPE_CODE LIKE '%MOVE%' AND (SYSDATE - TO_DATE(TO_CHAR(TRIBE_ORDER.RAISED_DATE,'DD_MON_RR ')))<=30) T1
WHERE D_ACCOUNT.ACCOUNT_NO = T1.MORGANE_ACCOUNT_NUMBER (+)) T WHERE FP.BILL_ACCNT_KEY = T.ACCOUNT_NO);
In the above queries first query TAC_003 has run fine it has finished in 3 min, and It updated the records fine but when I fire second query TAC_007 it has not updated records after 2hrs I have stopped query and I have put <100 rows that time it updated but I want to update 80K records. Can any one help on this?
I have tried Index also.