Poor performance when updating Promotion Event
UPDATE PROMOTION_DATA SET (CASE_OI,PROMO_PRICE,LAST_UPDATE_DATE) = (SELECT :1 CASE_OI
,:2 PROMO_PRICE
,SYSTIMESTAMP LAST_UPDATE_DATE
FROM T_UPDATE_283_1344923078455 T_UPDATE_LIST
WHERE PROMOTION_DATA.PROMOTION_ID = T_UPDATE_LIST.PROMOTION_ID
AND PROMOTION_DATA.SALES_DATE = T_UPDATE_LIST.SALES_DATE
AND PROMOTION_DATA.LOCATION_ID = T_UPDATE_LIST.LOCATION_ID