Update is slow
UPDATE ecg_study es
SET es.r_mc_ecg_confirm_status =
(SELECT DECODE(ps.ps_ecg_confirm_type,
NULL,
173,
DECODE(ps.ps_ecg_confirm_type, 168, 172, 173))
FROM /*ecg_study es,*/ protocol_study ps
WHERE es.ps_protocol_id = ps.ps_protocol_id(+)
AND es.r_mc_ecg_confirm_status NOT IN (172, 173, 174))
-Thanks