Thursday, November 25, 2010

SQL Server:Execution Time Calculation For Queries

Hi,
This is the example for calculating Query execution time in SQL
The procedure is very simple, first take start time of query execution and then write the query and then get the end time of query execution and then calculate their difference



And below is the execution plan for the query

For execution plan you have to just run the query and click on the icon menu i.e. Display Estimated Execution Plan



Happy Coding,
Regards,
Krunal Panchal

No comments:

Post a Comment