这在在oracle执行计划中对该语句执行的统计.
select wtd_no,wtzh,xmbh,wtrq,zzrq,chuchangrq,jgbw,pz,qddj,jcry1_name,jcrq1,jcrq2,jc_wcflag,sh_wcflag,wt_wcflag,shry_name,shrq,cpbz
from rws
where substr(xmbh,1,2)= 'hn'
and CHUCHANGRQ<='2004-09-11'
and JC_WCFLAG ='未完成'
ORDER BY xmbh--在JC_WCFLAG上建索引或建函数substr(xmbh,1,2)索引. 用到了排序,是会降低速度的.
select wtd_no,wtzh,xmbh,wtrq,zzrq,chuchangrq,jgbw,pz,qddj,jcry1_name,jcrq1,jcrq2,jc_wcflag,sh_wcflag,wt_wcflag,shry_name,shrq,cpbz
from rws
where substr(xmbh,1,2)= 'hn'
and CHUCHANGRQ<='2004-09-11'
and JC_WCFLAG ='未完成'
ORDER BY xmbh--在JC_WCFLAG上建索引或建函数substr(xmbh,1,2)索引. 用到了排序,是会降低速度的.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货