not in 和 not 效率区别

最新推荐文章于 2023-02-13 22:07:32 发布

millerrch

最新推荐文章于 2023-02-13 22:07:32 发布

阅读量245

点赞数

分类专栏： SQL语句文章标签： ui

本文链接：https://blog.csdn.net/millerrch/article/details/84096604

版权

SQL语句专栏收录该内容

3 篇文章 0 订阅

订阅专栏

update sso.m_user_info ui set ui.sjfw=(
   select oimu.organize_detail_code from
(select * from sso.m_organize_info oi inner join sso.m_organize_user mu on mu.organize_code=oi.organize_code
   ) oimu inner join m_user_info ui1 on ui1.user_code=oimu.user_code where ui.login_name=ui1.login_name and rownum<2
)
where ui.user_code
not in(
select mu.user_code from sso.m_organize_info oi inner join sso.m_organize_user mu on oi.organize_code=mu.organize_code
    where oi.organize_bm like '370211%' or oi.organize_bm like '37020028%' or
          oi.organize_bm like '37020003%' or oi.organize_name like '%法制%'
)
=======

上面的语句用了157S
而下面的语句用了仅3S

update sso.m_user_info ui set ui.sjfw=(
   select oimu.organize_detail_code from
(select * from sso.m_organize_info oi inner join sso.m_organize_user mu on mu.organize_code=oi.organize_code
   ) oimu inner join m_user_info ui1 on ui1.user_code=oimu.user_code where ui.login_name=ui1.login_name and rownum<2
)
where ui.user_code in(
select mu.user_code from sso.m_organize_info oi inner join sso.m_organize_user mu on oi.organize_code=mu.organize_code
    where oi.organize_bm not like '370211%' and oi.organize_bm not like '37020028%' and
          oi.organize_bm not like '37020003%' and oi.organize_name not like '%法制%'
)

millerrch

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
not in 和 not 效率区别

update sso.m_user_info ui set ui.sjfw=( select oimu.organize_detail_code from (select * from sso.m_organize_info oi inner join sso.m_organize_user mu on mu.organize_code=oi.organize_code ) oimu...
复制链接

扫一扫