执行如下SQL : insert into st_userflow_all_1440_20121102(sttime,hh,mi,srcid,desid,lacid,sac,imsi,msisdn,imei,hlr,interfacetype,rattype,serviceid,areaid,
recvpacket,sendpacket,recvoct,sendoct,alloct,delays,users,sendlosspkt,recvlosspkt,sendretranspkt,recvretranspkt,termdelay,netdelay
)
select dateformat(sttime,''yyyy-mm-dd'')||'' 00:00:00'' st,0 hh,0 mi,srcid,desid,lacid,sac,imsi,msisdn,imei,hlr,interfacetype,rattype,serviceid,areaid,
sum(recvpacket),sum(sendpacket),sum(recvoct),sum(sendoct),sum(alloct),sum(delays),sum(users),sum(sendlosspkt),
sum(recvlosspkt),sum(sendretranspkt),sum(recvretranspkt),sum(termdelay),sum(netdelay)
from st_userflow_all_60_20121102 a
group by dateformat(sttime,''yyyy-mm-dd'')||'' 00:00:00'',srcid,desid,lacid,sac,imsi,msisdn,imei,hlr,interfacetype,rattype,serviceid,areaid
总共有45460682条记录,花了两个小时40分钟,问下有什么优化策略没?数据库是Sybase 12.7 IQ。非常谢谢 |