0 out of 1 rated this helpful - Rate this topic

Analyzing Queries

SQL Server 2000

Among the most important features of SQL Query Analyzer are the tools to help you analyze your queries for optimal performance. These tools include:

  • Show Query Execution Plan.

  • Show Estimated Execution Plan.

  • Show Server Trace.

  • Show Client Statistics.

  • Index Tuning Wizard.

See Also

Viewing the Query Execution Plan

Viewing the Estimated Query Execution Plan

Viewing Server Trace Information

Viewing Client Statistics Information

Tuning Indexes

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.