SQL优化之in and Exsits

最新推荐文章于 2024-05-04 18:48:13 发布

出埃及

最新推荐文章于 2024-05-04 18:48:13 发布

阅读量840

点赞数

分类专栏： Oracle Sql Tuning 文章标签：优化 sql

本文链接：https://blog.csdn.net/Coast_lichao/article/details/7574400

版权

Oracle Sql Tuning 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

这个SQL是帮网友优化的，很简单：

30s返回结果：
select * from B11QUA_three 
   where project_id='TJWQSZ' 
     and type='04'
     and times='初检' 
     and suggestion='通过' 
     and sid not in 
           (select isnull(cj_sid,0) from B11QUA_three 
              where project_id='TJWQSZ'
                 and type='04'
             and times='复检'  
                         and suggestion='通过');
1s返回结果：
select * from B11QUA_three a
   where project_id='TJWQSZ' 
     and type='04'
     and times='初检' 
     and suggestion='通过' 
     and not exsit 
           (select 1 from B11QUA_three b
              where a.sid=b.cj_sid
                 and project_id='TJWQSZ'
                 and type='04'
             and times='复检'  
                         and suggestion='通过')