标题: 如何提高查询语句的效率 [打印本页] 作者: congfu 时间: 2015-03-18 16:53 标题: 如何提高查询语句的效率 select * from (
select a.*
from v_zyjz a
where a.dfyxx09 >= &adt_start
AND a.dfyxx09 < &adt_end
and a.sjflb01 like 'BD01%'
and ( exists
(select * from V_ZYYPMX b
where a.SZYBH01 = b.szybh01
and a.SYZXH01 = b.SYZXH01
and a.IFYXH01 = b.ifyxh01
and (( b.LX in ('A','F','G','H') and ( b.dfysj01 <&adt_start or b.dfysj01 >= &adt_end ) )
or b.LX in ('B','C','D','E')
)))
or ( ( not exists
(select * from V_ZYYPMX b
where a.SZYBH01 = b.szybh01
and a.SYZXH01 = b.SYZXH01
and a.IFYXH01 = b.ifyxh01 )
or a.szxbz01 = '0' )
) )
