这条SQL语句怎么优化,马上给分
select room.id as id ,room.roomid as roomid ,device.wychargemeterdeviceid as bh ,record.valuediff as actualvalue,record.approtion as approtion,record.value as value ,record.meterdevicerecordid as meterdevicerecordid ,device.chargemeterdeviceid as chargemeterdeviceid ,
device.beishu as bs , param.lowdegree,param.firstrange,param.secondrange,param.thirdrange,
param.neededcalculatefee ,param.normalprice,param.firstrangeprice,param.secondrangeprice,param.thirdrangeprice , record.addvalue as addvalue from wy_room as room inner join jf_chargemeterdevice as device using(id)
inner join jf_chargemeterparam as param using (chargemeterparamid)
left join jf_chargemeterdevicerecord as record on(device.chargemeterdeviceid=record.chargemeterdeviceid
and param.chargemeterparamid = record.chargemeterparamid )
left join jf_calculaterecord as cal using (calserial)
where room.buildingareaid='0613021207_1000000000000002462' and room.buildingid='0724044445_1000000000000031287'
and device.type='电表' and cal.calserial '0918094046_1000000000000053836' order by room.roomid
求教高手,这条语句怎么优化?
数据量少的时候,没有问题,数据多时CPU跑到100%,这是怎么拉
高手帮帮我好吗?解决马上给分
先谢谢啦