老哥们帮帮忙优化下sql语句 执行太慢了

[shjdssxsyydaw]

SELECT a.vend_id AS 供应商代号,
a.vend_cname AS 供应商名称,
decode(a.vend_kind,'J','付款供应商') AS 供应商大类,
decode(a.send_type,'Q','企业法人(含友厂)','0','其他' ) AS 供应商中类,
a.mgr_factno AS 管理厂,
b.factname AS 厂别名称,
a.contacter AS 联系人,
a.vend_tel AS 联系电话,
a.vend_email AS 邮箱
FROM pec.prh092t3 a, pec.pec029t0 b
WHERE a.vend_kind = 'J'
AND a.send_type NOT IN ('P', 'G')
AND a.inval_date IS NULL
AND a.grpno = '01'
AND a.mgr_factno = b.factno
AND b.grpno = '01'
AND a.vend_id IN
(SELECT c.object_no FROM pec.acs340t0 c WHERE c.yyyymm > '201605'and c.object_no like'%I00%')
ORDER BY a.vend_id;

[shjdssxsyydaw]

AND a.vend_id IN (SELECT c.object_no FROM pec.acs340t0 c WHERE c.yyyymm > '201605'and c.object_no like'%I00%') 就是这句 把这句注释掉几秒就出结果了

[js14982]

改成exists试试

[jdsnhan]

把acs340t0 表放在外层做关联查询，不以子查询的形式体现