公司Oracle更新忒别慢,没治了
update timeuvh u
set(u.last_uv_dt) = (select last_tm from (select h.account_id,max(h.atime) last_tm
from halltime h group by h.account_id)hh
where u.account_id=hh.account_id)
where exists (select 1 from (select h.account_id,max(h.atime) last_tm
from halltime h group by h.account_id)hh
where u.account_id=hh.account_id)
查找重新insert into delete 吧