Index Tuning Wizard
Deciding which indexingstrategy to apply is not an easy task. Different queries can be optimized in different ways using different indexes. To decide which is the best indexing strategy, it would be necessary to consider statistically which strategy produces the best global performance.
The Index Tuning Wizard does just that. It uses a trace from SQL Profiler to analyze, propose, and apply, if required, the best indexing strategy for the actual database workload.
With the integration of the Index Tuning Wizard in SQL Query Analyzer, it is possible to optimize a single query or batch in Query Analyzer, without creating a trace with SQL Profiler. This can be considered as a provisional solution, to speed up the process of one ...
Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
