在zch、nbxh、clrq创建索引select zch,fddbr,zs,qymc from hz_qyhznr
where
zch like '3307823%'
and exists (select 1 from nbxh hz_yhzjl where hz_yhzjl.nbxh = hz_qyhznr.nbxh ae_y in ('2000','2001'))
and clrq<todate('2000-12-31','yyyy-mm-dd')
order by zch;
where
zch like '3307823%'
and exists (select 1 from nbxh hz_yhzjl where hz_yhzjl.nbxh = hz_qyhznr.nbxh ae_y in ('2000','2001'))
and clrq<todate('2000-12-31','yyyy-mm-dd')
order by zch;
and clrq<to_date('2000-12-31','yyyy-mm-dd')
要不然首先在你的子查询都可能浪费很多时间,因为它是全文检索。
minus
select nbxh from hz_qyhznr;