查询SQL语句的执行速度代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】查询SQL语句的执行速度

作者:Dezai.CN / 发布于2012/2/21/ 823

在各个select语句前加： declare @d datetime set @d=getdate() 并在select语句后加： select [语句执行花费时间(毫秒)]=datediff(ms,@d,getdate())

<div><span><span class="keyword"><span id="1329794878821S" style="display: none;"></span>declare</span><span> @d datetime  </span></span></div>
<div><span><span class="keyword">set</span><span> @d=getdate()  </span></span></div>
<div><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> zzx  </span></span></div>
<div><span><span class="keyword">select</span><span> [语句执行花费时间(毫秒)]=datediff(ms,@d,getdate()) </span></span></div>
<div></div>
<div><span><span>--另一方法</span></span></div>
<div><span><span>
<div><span><span class="comment"><span id="1329794910417S" style="display: none;"></span>--显示分析、编译和执行各语句所需的毫秒数.</span><span>  </span></span></div>
<div><span><span class="keyword">set</span><span> </span><span class="keyword">statistics</span><span> </span><span class="keyword">time</span><span> </span><span class="keyword">on</span><span>   </span></span></div>
<div><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> zzx  </span></span></div>
<div><span><span class="keyword">set</span><span> </span><span class="keyword">statistics</span><span> </span><span class="keyword">time</span><span> </span><span class="keyword">off</span><span class="comment">--这里查询完直接关闭<span id="1329794909732E" style="display: none;"></span>了</span><span>  </span></span></div>
</span></span></div>
<div></div>
<div><span id="1329794878848E" style="display: none;"></span></div>

试试其它关键字

　执行速　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)