Statistics IO and Time

SET STATISTICS IO, TIME ON

Statistics IO is going to give us the number of IO operations that SQL Server’s going to do to service our queries, and it’s going to break that down by logical reads from memory and physical reads from disk. 

The time statistic is just going to give us the actual execution time and it’s going to be broken down by CPU and overall time to return the query.