devxlogo

Display Statistics to Parse, Compile, and Execute Each SQL Statement

Why Trust Us

This T-SQL command can be used to display the number of milliseconds required to parse, compile, and execute each statement. When SET STATISTICS TIME is ON, the time statistics for a statement are displayed. When OFF, the time statistics are not displayed. This option can be used to compare the performance of modifications made to queries and/or indexes.Syntax is:

 SET STATISTICS TIME {ON | OFF}

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  How Engineering Leaders Spot Weak Proposals
Disclosure

About Our Editorial Process

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.

Show More