One, SET STATISTICS IO (about the amount of disk activity generated by the TSQL statement query)
Scan Count: The number of times a table is accessed in a query;
logical reads: The number of pages of data read from the data buffer;
physical reads: The number of pages of data read from the physical disk to buffer;
Read -ahead: The number of pages of data read from the physical disk to buffer according to the execution plan;
--Displays information about the amount of disk activity generated by the Transact-SQL statement set STATISTICS IO on--shutdown information about the amount of disk activity generated by the Transact-SQL statement set STATISTICS IO off
Second, SET STATISTICS time (SQL Server parsing and compilation times)
1, CPU time. Compare the CPU resource time to be consumed by the query;
2, I/O. The number of circular scans and the amount of data logically read can be compared.
Http://blog.sina.com.cn/s/blog_a637e97e010131cb.html
How to view performance metrics for queries with SQL statements