2段SQL效能比較

最新推荐文章于 2024-10-14 18:59:57 发布

xiangsu

最新推荐文章于 2024-10-14 18:59:57 发布

阅读量1.4k

点赞数

分类专栏：程序春秋文章标签： sql null

本文链接：https://blog.csdn.net/xiangsu/article/details/479064

版权

程序春秋专栏收录该内容

2 篇文章 0 订阅

订阅专栏

--SEQ_A:
select A.* from t_brdl_acry_prog A,t_brdl_acry_deta B
where A.acry_seq_no=B.acry_seq_no and A.acry_no='M022591' and A.out_box is not null
and A.acry_seq_no not in (select distinct isnull(acry_seq_no,'') from t_brdl_acry_pack)

--SEQ_B:
select A.* from t_brdl_acry_prog A with(nolock),t_brdl_acry_deta B with(nolock)
where A.acry_seq_no=B.acry_seq_no and A.acry_no='M022591' and A.out_box>''
and not exists(select acry_seq_no from t_brdl_acry_pack with(nolock) where acry_seq_no=a.acry_seq_no)

Ctrl+L 查看效能