--显示有关由Transact-SQL 语句生成的磁盘活动量的信息
SET STATISTICS IO ON;
SET STATISTICS IO OFF;
SET STATISTICS PROFILE ON;
SET STATISTICS PROFILE OFF;
--显示[返回有关语句执行情况的详细信息,并估计语句对资源的需求]
SET SHOWPLAN_ALL ON:
SET SHOWPLAN_ALL OFF:
--索引统计信息
dbcc show_statistics (table_name , index_name )