3 Tricks with STATISTICS IO and STATISTICS TIME in SQL Server
Category:
query-performance
, sql-server
When you need to measure how long a query takes and how many resources it uses, STATISTICS TIME and STATISTICS IO are great tools for interactive testing in SQL Server. I use these settings constantly when tuning indexes and query.