Tag Archives: SET STATISTICS

SET STATISTICS IO ON; SET STATISTICS TIME ON – performance tuning

SET STATISTICS IO ON and SET STATISTICS TIME ON are beautiful ways which can be used while performance tuning individual queries. SET STATISTICS IO ON Enabling STATISTICS IO is very informative as it displays Scan count, logical reads, physical reads, … Continue reading

Posted in Performance, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment