sql question 5

3 Jun 2005 6:50 AM

ichor

34. (34) You are a database developer for an 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?

A. Execute each query in SQL Query Analyzer, and use the SHOWPLAN_TEXT
option. Use the output for the report.
B. Execute each query in SQL Query Analyzer, and use the Show Execution Plan
option. Use the output for the report
C. Run the Index Tuning Wizard against a Workload file. Use the output for
the report
D. Execute the DBCC SHOW_STATISTICS statement. Use the output for the report

Ans:C
Testking said A

what is the right answer and why?

3 Jun 2005 7:03 AM

John Bell

Hi

Once the ITW has completed it gerates and index usage report.

e.g. http://www.sql-server-performance.com/lm_index_elimination_english.asp
which actually uses it for the converse i.e. to identify unused indexes.

John

Show quoteHide quote

"ichor" <ic***@hotmail.com> wrote in message
news:ORWfDiAaFHA.2900@TK2MSFTNGP15.phx.gbl...
> 34. (34) You are a database developer for an 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?
>
> A. Execute each query in SQL Query Analyzer, and use the SHOWPLAN_TEXT
> option. Use the output for the report.
> B. Execute each query in SQL Query Analyzer, and use the Show Execution
> Plan option. Use the output for the report
> C. Run the Index Tuning Wizard against a Workload file. Use the output for
> the report
> D. Execute the DBCC SHOW_STATISTICS statement. Use the output for the
> report
>
> Ans:C
> Testking said A
>
> what is the right answer and why?
>
>