You are a database developer for a SQL Server 2000 database. You are planning to add new indexes, drop some indexes, and change other indexes to composite and covering indexes. For documentation purposes, you must create a report that shows the indexes used by queries before and after you make changes. What should you do?

234.

You are a database developer for a SQL Server 2000 database.
You are planning to add new indexes, drop some indexes, and change other indexes to composite and covering indexes.
For documentation purposes, you must create a report that shows the indexes used by queries before and after you make changes.
What should you do?

Execute each query in SQL Query Analyzer, and use the SHOWPLAN_TEXT option. Use the output for the report.

Execute each query in SQL Query Analyzer, and use the Show Execution Plan option. Use output for the report

Run the Index Tuning Wizard against a Workload file. Use the output for the report.

Execute the DBCC SHOW_STATISTICS statement. Use the output for the report.

View Description

No description found.