dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday Mar 29th 2018 by Hannes du Preez

Language: SQL, Expertise: Intermediate - Easily figure out the amount of time spent on a query and the reads and writes of the query in question.

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;
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved