求SQL语句优化
Eri 2008-01-23 03:31:30 select *
from t_weblog a where bk_abbPaytime between '2008-01-13' and '2008-01-19'
and bk_payCode not in(select bk_paycode from t_banklog a
where bk_abbPaytime between '2008-01-13' and '2008-01-19')
每一个查询单独查的话速度都在0秒,就是Not In的时候要几分钟。
求一下语句上面的优化。