The Index Tuning Wizard
The Index Tuning Wizard is a utility provided by SQL Server that can analyze a set of queries and make recommendations about the right mix of indexes or indexed views that could be defined to improve performance. You can also specify that the Index Tuning Wizard generate a SQL script to implement the index design that it recommends.
The Index Tuning Wizard does a great job of quickly analyzing a database and recommending a basic set of indexing options. Of course, it is not perfect, and it can make mistakes by not recommending an index that it should or by recommending a less than optimal index.
Although the recommended design might not be perfect, the Index Tuning Wizard provides an excellent starting point for any indexing ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.
