Thanks !You can use Microsoft SQL Query Analyzer that ships with SQL Server.
It allows you to view the execution path, and how long each part of your query takes.
Start SQL Profiler and then execute your queries via Enterprise Manager or Query Analyzer. All products are part of the client tools installed with MS SQL.
Also, in Query Analyzer you should turn on show execution plan.
0 comments:
Post a Comment