devxlogo

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

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

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}

devx-admin

Share the Post: