---第一种方法定义起止时间:
declare @begin_date datetime
declare @end_date datetime
select @begin_date = getdate()
-------要执行的SQL语句
select * from CBO_Account
----------
select @end_date = getdate()
select datediff(ms,@begin_date,@end_date) as '用时/毫秒'
结果如下:
-----第二种方法,将执行每个语句时采取的步骤作为行集返回,通过层次结构树的形式展示出来
set statistics profile on
set statistics io on
set statistics time on
--写SQL语句的地方
select * from CBO_Account
set statistics profile off
set statistics io off
set statistics time off
结果如下图:
第三种方法 ,用Sql Server 自带的工具
位置:工具》选项》查询执行》高级