mssql 判断sql语句的执行效率语句

SET STATISTICS io ON
SET STATISTICS time ON
go
--========此处为sql代码段===============
select zxbh from t_yr03_zxxx
where k_gh='0DF41D83-E0CE-4928-B838-76ACC84F1A4C' and sfct=1
and exists (select k_zx from t_yr05_ctzx ctzx where ctzx.k_zx=t_yr03_zxxx.k_zx
and exists (select k_ct from t_yr05_ct where ctzx.k_ct =k_ct and k_gh='0DF41D83-E0CE-4928-B838-76ACC84F1A4C'
and k_sjjd in (select k_zd from t_ps03_zd where bm='R.BGZL.01' or bm ='R.BGZL.02') and ywzt=4))
--========此处为sql代码段===============

go
SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF

原文地址:https://www.cnblogs.com/Strive-fighting/p/3341229.html