what's wrong with this update SQL spy_mart 12.5 millions and spy_proc_prov 2.4 millions. It's take me 17 hours already and still going now on Oracle 9.2 Solaris Sun update spy_proc_prov p set (p.paid_total,p.claim_ct) = (select sum(m.paid_amt), count(m.proc_cd) from spy_mart m where p.prov_id = m.prov_id and p.proc_cd=m.proc_cd group by prov_id, proc_cd) Thanks, Vu