select ta.mdmc,ta.louceng,ta.spid,ta.spmc,tb.xsze from (select * from zg_sysinfo where mdmc='江北店' and louceng in (select distinct louceng from jhyb_user where mdmc='江北店' and name = 'ysbin' ) )ta join (select mdmc,loudong,louceng,quyu,spid,spmc,sum(xsze)xsze from view_xshb where rq>='2023-01-25' and rq<='2023-02-08' group by mdmc,loudong,louceng,quyu,spid,spmc ) tb on ta.mdmc=tb.mdmc and ta.louceng=tb.louceng and ta.spid=tb.spid /* 描述：从zg_sysinfo这张基础上筛选出门店和当前户名所在的楼层商铺信息，再关联销售合并的视图view_xshb
select * from zg_sysinfo 1767条记录 select * from jhyb_user 907条记录 select * from view_xshb 视图19万记录 1.25-2.8日时间段内867条记录 */ 看语句很简单，但执行很慢，需要70秒，这是什么原因？需要怎么优化，感谢！ |
1min目标场景问卷
立即参与
