现有情况为A库及B库互相做联合体insert语句如下,数据量约400W+:INSERT INTO EC_CUST_CGT_LMT_TEST (ORG_CODE,CUST_CODE,CGT_CODE,QTY_LMT,NOTE,UP_TIME) SELECT COM_ID,CUST_ID,ITEM_ID,LMT_QTY,NOTE,'2014-02-11 16:35:02' FROM SRM_XSM_CUST_IT...
显示全部现有情况为A库及B库互相做联合体insert语句如下,数据量约400W+:
INSERT INTO EC_CUST_CGT_LMT_TEST (ORG_CODE,CUST_CODE,CGT_CODE,QTY_LMT,NOTE,UP_TIME)
SELECT COM_ID,CUST_ID,ITEM_ID,LMT_QTY,NOTE,'2014-02-11 16:35:02'
FROM SRM_XSM_CUST_ITEM_LMT
WHERE COM_ID='11230101'
其中SRM_XSM_CUST_ITEM_LMT表在A库,EC_CUST_CGT_LMT_TEST 表在B库
该SQL在A库执行需要大约18分钟,在B库执行仅需要2-3分钟,请问下解决思路?程序是写在A库执行的,有什么办法可以优化吗?附件附上A库及B库的访问计划,请教各位大神,谢谢!
附件:
lmt_A.out (6.54 KB)
lmt_B.out (7.97 KB)
limit_A_test1.out (7.1 KB)
收起