1.查看SQL语句IO消耗
set statistics io on select * from dbo.jx_order where order_time>'2011-04-12 12:49:57.580' set statistics io off
2.查看SQL语句时间消耗
set statistics time on select * from dbo.jx_order where order_time>'2011-04-12 12:49:57.580' set statistics time off
3.查看SQL语句索引消耗
set statistics profile on select * from dbo.jx_order where order_time>'2011-04-12 12:49:57.580' set statistics profile off
此上图中的红框可以看到此查询走了聚集索引扫描
转载于:https://www.cnblogs.com/mrwei/p/3829888.html
