tb_e_zw_nrllb_temp 量700225
gsm_user 量109398337
--优化前 两种update
--说明:gsm_user是视图存在GSM_USER_ID索引,tb_e_zw_nrllb_temp有user_id索引,使用以下两种方法都更新时间超5h+导致不能更新成功
--1
update tb_e_zw_nrllb_temp t
set t.msisdn = (select msisdn from from gsm_user a
where to_char(a.GSM_USER_ID) = b.user_id
and b.settle_month = p_month_id))
where .settle_month = p_month_id;
--2
merge into tb_e_zw_nrllb_temp t
using gsm_user a
on (to_char(a.GSM_USER_ID) = t.user_id )
when matched then
update set
t.msisdn = a.MSISDN
where t.settle_month = p_month_id;
commit;
--优化后
--优化后时间耗费主要在insert上,insert的select查询比较快,因此又想办法优化inser