oracle not exists效率比not in高

来源:互联网 发布:淘宝正品aj鞋店 编辑:程序博客网 时间:2024/06/05 18:49

select count(1) from t1 a where not exists (select null from t2 b where b.no = a.uuid)


select * from t1 a where a.proxyid not in (
select c.proxyid from t2 b,t1 c where b.no = c.uuid)

功能一样,但not exists效率比not in高


0 0