求大神帮我优化一下语句，我这段语句查询出来需要5分钟左右，

hou582123849 2017-04-05 04:58:35

SELECT '货款部分' as cls,
stlchk.stlchkno,
stlchk.mkedat,
(select empdes from emp where empid=stlchk.mkr) as mkr,
gdsbuy.srcbllno,
round(sum(gdsbuy.amt),2) as bivcdtl_amt,
round(sum(gdsbuy.patamt),2) as bivcdtl_patamt,
(select distinct '['+rtrim(bll.bllid)+']'+blldes from bll where bll.bllid=gdsbuy.bllid) as blldes,
gdsbuy.ctno,
(select openaccbnkr from prv where prvid=stlchk.prvid) as op,
(select actno from prv where prvid=stlchk.prvid) as actno,
(select bnk from prv where prvid=stlchk.prvid) as abnk,
(select dptid from dpt where dptid in (select savdptid from stkin where stkinno=gdsbuy.srcbllno)) as fd,
(select '['+rtrim(prvid)+']'+prvdes from prv where prvid = stlchk.prvid) as prvdes
FROM ((stlchk inner join stlbll on stlchk.stlchkno=stlbll.stlchkno) inner join bivc on bivc.bivcno = stlbll.lnkstlno) inner join gdsbuy on bivc.bivcno=gdsbuy.lnkivcno
WHERE stlchk.prvid like :as_prvid and
stlchk.mkedat>= :as_bdate and stlchk.mkedat<= :as_edate and stlchk.mkr in (select empid from emp where dptid <>'311') and
gdsbuy.bstlflg='y'
GROUP BY stlchk.stlchkno,
stlchk.prvid,
stlchk.mkedat,
stlchk.mkr,
gdsbuy.bllid,
gdsbuy.srcbllno,
gdsbuy.ctno
union
SELECT '费用部分' as cls,
stlchk.stlchkno,
stlchk.mkedat,
(select empdes from emp where empid=stlchk.mkr) as mkr,
'' as srcbllno,
0 as bivcdtl_amt,
sum(stlchkdtl.feeamt) as bivcdtl_patamt,
(select '['+rtrim(feeitm.feeitmid)+']'+feeitm.feeitmdes from feeitm where feeitm.feeitmid = stlchkdtl.feeitmid ) as blldes,
'' as ctno,
'' as op,
'' as actno,
'' as abnk,
'' as fd,
'' as prvdes
FROM stlchk,
stlchkdtl
WHERE stlchk.prvid like :as_prvid and stlchkdtl.stlchkno=stlchk.stlchkno and
stlchk.mkedat>= :as_bdate and stlchk.mkedat<= :as_edate and stlchk.mkr in (select empid from emp where dptid <>'311')
group by stlchk.stlchkno,
stlchk.mkedat,
stlchk.mkr,
stlchkdtl.feeitmid
小弟实在没啥分了...跪谢各位大神！

...全文