INSERT INTO A(DW,ND,YD,jh,jdm,HSQK,QKMC,YCMC,GLCCBH,xmbh,je,yhm)
SELECT
P_DW,P_ND,P_YD,JH,JDM,HSQK,QK,CW,GLCCBH,substr(xmbh,1,8),sum(cdje),p_yhm
FROM B
WHERE GLCCBH LIKE V_GLCCBH||'%' AND ND=P_ND AND YD0
GROUP BY JH,JDM,HSQK,QK,CW,GLCCBH,SUBSTR(XMBH,1,8);
在B表(B表有800多万条记录)中按照一定的规则提取数据,向A表中插入,可是插入等待时间需要近8分钟、漫长……;B、C两表我已经加过索引了……谁能帮帮我提高插入效率
|