如何把下边的这个sql优化的更快

Question

select g.cid,g.provincebk,g.addressbk,g.addrMasterbk,g.telbk,g.remarksbk,g.qualifiedFlgbk,g.priceStatusbk,g.takeFoodFlgbk,g.upImagebk,g.upVideobk,g.orderDetailsbk,g.amountbk,g.bankModebk,g.maxDate as mdate,f.maxRedDate,(to_days(now()) - to_days(f.maxRedDate)) as dfDate from (select t.cumId as cid,t.province as provincebk,t.address as addressbk,t.addrMaster as addrMasterbk,t.tel as telbk,t.remarks as remarksbk,t.qualifiedFlg as qualifiedFlgbk,t.priceStatus as priceStatusbk,t.takeFoodFlg as takeFoodFlgbk,t.upImage as upImagebk,t.upVideo as upVideobk,l.orderDetails as orderDetailsbk,l.amount as amountbk,l.bankMode as bankModebk,l.orderDate as maxDate from t_rsgcustomer as t left join (select * from t_rsgmange as a where a.orderDate=(select max(b.orderDate) from t_rsgmange as b where b.cumId=a.cumId) group by a.cumId) as l on t.cumId = l.cumId group by t.cumId) as g left join (select e.cumId as cid,max(e.orderRedDate)as maxRedDate from t_rsgmange as e group by e.cumId) as f on g.cid = f.cid group by g.cid order by g.cid+0

Answer 1

可以把查询计划贴出来一块分析一下