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;
At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.
See our full editorial policy.
