Tip: Statistics IO and Statistics Time

Easily figure out the amount of time spent on a query and the reads and writes of the query in question.

by Hannes Du Preez

Mar 29, 2018

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 TABLE

SET STATISTICS IO OFF;
SET STATISTICS TIME OFF;

Visit the DevX Tip Bank

Thanks for your registration, follow us on our social networks to keep up-to-date