O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required