Statistics IO and Statistics Time

STATISTICS IO?and STATISTICS TIME?show the amount of time spent on a query and the reads and writes of the query in question. This is good to know for quick performance testing.

SET STATISTICS IO ON;SET STATISTICS TIME ON;SELECT COLUMNLIST FROM TABLESET STATISTICS IO OFF;SET STATISTICS TIME OFF;
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: