查看sql的执行效率

一、显示的信息比较全

SET STATISTICS io ON

        SET STATISTICS time ON

        go

  ---你要测试的sql语句

select g.grpName,t.grpID,t.flowID,t.typeName,t.description

from hyGroup g  ,hyType t where  t.grpID = g.flowID      

        go

        SET STATISTICS profile OFF

        SET STATISTICS io OFF

        SET STATISTICS time OFF

二、只显示执行时间

declare @d datetime set @d=getdate()

  ---你要测试的sql语句

select * from tablename

select[语句执行花费时间(毫秒)]=datediff(ms,@d,getdate())