You are a database developer for your company's SQL Server 2000 database. You update several stored
procedures in the database that create new end-of-month reports for the sales department. The stored
procedures contain complex queries that retrieve data from three or more tables. All tables in the
database have at least one index.
Users have reported that the new end-of-month reports are running much slower than the previous
version of the reports. You want to improve the performance of the reports.
What should you do?

A. Create a script that contains the Data Definition Language of each stored procedure.
Use this script as a workload file for the Index Tuning Wizard
B. Capture the execution of each stored procedure in a SQL Profiler trace.
Use the trace file as a workload file for the Index Tuning Wizard.
C. Update the index statistics for the tables used in the stored procedures.
D. Execute each stored procedure in SQL Query Analyzer, and use the Show Execution Plan option
E. Execute each stored procedure in SQL Query Analyzer, and use the Show Server Trace option

Ну тут я доверился TestKing'у и выбрал E. Но аргументы тут какие могут быть? Вроде и B и D тоже
ничего варианты...