17,377
社区成员
发帖
与我相关
我的任务
分享
select a.KFDM,a.ksxm,d.sbjname,count(a.KFDM) as KFCS from TBLDRV_KM" + koufenjilu + "_KOUFENJILU a , TBLDRV_KAOSHICHENGJI" + chengji + " b ,TBLDRV_BAOMING c,TBLDRV_KM" + sbjconfig + "_SUBJECTCONFIG d where a.ZKZMHM=b.bmh and b.bmh=c.bmh and d.sbjid = a.ksxm and d.cartype='C1'
select a.KFDM,a.ksxm,d.sbjname,count(a.KFDM) as KFCS from TBLDRV_KM31_KOUFENJILU a join TBLDRV_KAOSHICHENGJI2 b on b.bmh=a.ZKZMHM join TBLDRV_KM2_SUBJECTCONFIG d on d.sbjid = a.ksxm join TBLDRV_BAOMING c on c.bmh=b.bmh where d.cartype='C1' group by a.kfdm,a.ksxm,d.sbjname order by a.ksxm;
这句查用了2.6秒,加上模板绑定列速度慢我就真不知道为什么了。select a.KFDM,a.ksxm,d.sbjname,count(a.KFDM) as KFCS from TBLDRV_KM31_KOUFENJILU a join TBLDRV_KAOSHICHENGJI2 b on b.bmh=a.ZKZMHM join TBLDRV_KM2_SUBJECTCONFIG d on d.sbjid = a.ksxm join TBLDRV_BAOMING c on c.bmh=b.bmh where d.cartype='C1' group by a.kfdm,a.ksxm,d.sbjname order by a.ksxm;
on后面的字段基本都有索引了,还是挺慢的,还有用了一下模板列用DataBinder绑定以后速度就不能看了。。。