注册

子查询很慢,如何优化

蒲公英 2025/01/07 370 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
该查询有很多字段,目前只显示了影响查询效率的字段,如何进行优化
select rownum as hs,
(select kmbh||'_'||kmmc
from CW_KJKMSZB
where kmbh = mx.kmbh and sszt = mx.sszt and kjnd = mx.kjnd and saasdm = mx.saasdm ) as kmbh
from cw_fzlrb fz
left join cw_pzlrmxb mx
on fz.kmbh = mx.guid
left join cw_pzlrzb zb
on mx.pzbh=zb.guid
LEFT JOIN (select nvl(sum(jfje),0)jfje,
nvl(sum(dfje),0)dfje,
wldc
from cw_fzlrb f
left join cw_pzlrmxb mx
on f.kmbh = mx.guid
left join cw_pzlrzb z
on mx.pzbh=z.guid
where
(nvl(dfje,0)<0 or nvl(jfje,0)<>0)
GROUP BY f.wldc)jfjeb
ON fz.wldc=jfjeb.wldc
left join cw_kjkmszb kmsz
on mx.kmbh=kmsz.kmbh and mx.sszt=kmsz.sszt and mx.kjnd=kmsz.kjnd AND MX.SAASDM=KMSZ.SAASDM
where MX.saasdm= '49557147X' and mx.sszt='B9BA12A24DBE4EA89763AFDE76B8C61A' and mx.kjnd='2024' AND MX.DFJE IS NOT NULL AND KMSZ.HSLB IN ( '04')

执行计划如下:
image.png

回答 0
暂无回答
扫一扫
联系客服