Report

This is general scanario and I want some feedback from you guys.
I am planning to add new indexes, drop some indexes, and change other
indexes to composite and covering indexes. I want to create report that
shows the indexes used by queries before and after I make changes. What
should I do?
Can anyone tell me that which one would be the best solution.
1) SHOWPLAN_TEXT option. Use the output for the report.
2) Show Execution Plan option. Use output for the report.
3) Tuning Wizard against a Workload file. Use the output for the report.
4) DBCC SHOW_STATISTICS statement. Use the output for the report.
> 1) SHOWPLAN_TEXT option. Use the output for the report.
Gives you an text ouput of the execution plan. Easy for such documentation

> 2) Show Execution Plan option. Use output for the report.
Gives a pictorial output. Tough for documentation purpose hence.

> 3) Tuning Wizard against a Workload file. Use the output for the report.
Great for all recommendations. Needs a very good workload to arrive at a
decent solution and suggestions.

> 4) DBCC SHOW_STATISTICS statement. Use the output for the report.
Gives the histogram output of the Indexes. Good to know on the selectivity
activity.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
http://groups.msn.com/SQLBang
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Noor" <noor@.ngsol.com> wrote in message
news:uhgj1N%23jEHA.1996@.TK2MSFTNGP09.phx.gbl...
> This is general scanario and I want some feedback from you guys.
> I am planning to add new indexes, drop some indexes, and change other
> indexes to composite and covering indexes. I want to create report that
> shows the indexes used by queries before and after I make changes. What
> should I do?
> Can anyone tell me that which one would be the best solution.
> 1) SHOWPLAN_TEXT option. Use the output for the report.
> 2) Show Execution Plan option. Use output for the report.
> 3) Tuning Wizard against a Workload file. Use the output for the report.
> 4) DBCC SHOW_STATISTICS statement. Use the output for the report.
>