2段SQL效能比較

--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 查看效能