有一段sql执行速度很慢 要50s
经查询是由于在sql的子查询中使用了递归查询导致
sql如下
select
(SELECT to_char(temp.rwwcsx, 'yyyy-mm-dd')
from (SELECT * FROM fxyd_rwdy_mx mx order by mx.rwdy_sj desc) temp
WHERE temp.fxxx_bh in (F_GET_SJ_FXXX_BH(t.fxxx_bh))
--(SELECT a.fxxx_bh
-- FROM fxyd_rwmx a
-- start with a.fxxx_bh = t.fxxx_bh
-- CONNECT BY a.fxxx_bh = PRIOR a.sj_fxxx_bh)
and temp.hxcl_dm = 'RWTC'
and temp.rwtczt_dm = 'YXF'
and temp.jsjg_dm = '23407000000'
and rownum = 1) sj_xf_rwwcsx, --取本机关的上级下发的完成时限
(SELECT jg.swjgcclx_bj
FROM wd_swjg jg
WHERE jg.swjg_dm =
(SELECT