oracle里not exists和not in 性能测试_sailorhu的记事本

来源：百度文库编辑：神马文学网时间：2024/05/24 01:45:04

2008-07-16 15:28 http://hi.baidu.com/sailorhu/blog

今天针对oracle里面not in 和not exists专门做了个性能测试：

条件：oracle10g，表A 有记录数3243条，表B有记录数943条。

测试工具：Yourkit 6.0 。

测试sql如下

select * from A where not exists ( select * from B where A.id = B.id )和

select * from A where A.id not in ( select * from B)

not exists 的结果如下图：执行了 193 ms

oracle里not exists和not in 性能测试_sailorhu的记事本 SQL中IN,NOT IN,EXISTS,NOT EXISTS的用法和差别 exists，not exists总结 SQL查询速度测试及Not Exists sql的not exists随笔 - J2ME - New - JavaEye论坛 is not in sudoer file Not In Your Face 揭示个性的背影摄影 Not In Your Face 揭示个性的背影摄影 In Defense of Not-Invented-Here Syndrome AVI DVC not playing in Media Player Error: Content is not allowed in prolog vc C2085 not in formal parameter list T恤文化：Not In Your Face I DO NOT LOOK THEM IN EYES The ‘OraOLEDB.Oracle.1‘ provider is not registered on the local machine的原因 The ‘OraOLEDB.Oracle.1‘ provider is not registered on the local machine的原因 - 使名扬 - 博客园 Write operations are not allowed in read-only... Biofuels in Brazil | Lean, green and not mean... China In L. America: Partner, Not Threat (So Far) Tesco: What Not to Do in a Down Economy China not to let yuan gain in short term: experts China In L. America: Partner, Not Threat (So Far) Better not to get married in 'Year of Tiger' main.o: could not read symbols: File in wrong format