代码如下,具体效果请在查询分析器中运行后查看
USE pubs
GO
SET STATISTICS profile ON
SET STATISTICS io ON
SET STATISTICS time ON
SELECT * FROM authors
SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF
USE pubs
GO
SET STATISTICS profile ON
SET STATISTICS io ON
SET STATISTICS time ON
SELECT * FROM authors
SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF