Skip to Main Content

Update is running long with temp transformation in execution plan

User_WVSC7Oct 2 2020

We have an update process that is running long and it seems like temp transformation plan lines are taking more time

UPDATE
COMSYS.BRANCH_BONUS_DETAIL A
SET
(
EXCLUDE_FLAG,
REASON ,
LAST_OSJ_DATE
)
=
(
SELECT
'Y',
A.REASON
||'5 - CHANGED OSJ ON '
||REP_LAST_OSJ_SWTCH_DT
||'|',
REP_LAST_OSJ_SWTCH_DT
FROM
COMSYS.REP_OSJ_SWITCH_VW_BRANCH_BONUS
WHERE
REP_ID = A.REP_ID)
WHERE
PAY_PERIOD = :B1
AND EXISTS
(
SELECT
'X'
FROM
COMSYS.REP_OSJ_SWITCH_VW_BRANCH_BONUS
WHERE
REP_ID = A.REP_ID
AND REP_LAST_OSJ_SWTCH_DT >= :B2 )
AND EXISTS
(
SELECT
'x'
FROM
COMSYS.REP
WHERE
REP_ID = A.REP_ID
AND MASTER_BANK_ID IS NULL
AND NVL(MASTER_ID,REP_ID) NOT IN
(
SELECT DISTINCT
MASTER_BANK_ID
FROM
COMSYS.REP
WHERE
MASTER_BANK_ID IS NOT NULL))

Comments
Post Details
Added on Oct 2 2020
12 comments
346 views