merge into ecc_ass.ecc_account_callout v
using (select h.customer_id,h.pri_card_id from ecc_bj.ecc_account h,ecc_ass.ecc_account_callout a where h.pri_card_id = a.pri_card ) h
on (v.pri_card = h.pri_card_id)
when matched then update set v.customer_id = h.customer_id
when not matched then insert (v.customer_id)
values(null)
我这样插入数据为何这么慢啊. 请问可是为何.
using (select h.customer_id,h.pri_card_id from ecc_bj.ecc_account h,ecc_ass.ecc_account_callout a where h.pri_card_id = a.pri_card ) h
on (v.pri_card = h.pri_card_id)
when matched then update set v.customer_id = h.customer_id
when not matched then insert (v.customer_id)
values(null)
我这样插入数据为何这么慢啊. 请问可是为何.
请问,在线等.,