子查询中使用了递归CONNECT BY巨慢的解决方案

有一段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