Некоторые рекомендации из Q311826:
- Before you run the ITW, update the statistics on your database
- If you run the ITW on a test system, make sure the tables, constraints, indexes, data selectivity, and number of rows are the same as those on your production system
- For the ITW to recommend indexes, there must be a significant amount of data in the tables being tuned
- If a potential index only provides a small benefit over an existing index, the potential index is not included in the recommendations
- Queries with optimizer hints are not tuned
- Refer to the Index Tuning Wizard topic in SQL Server Books Online for a list of items that can keep the ITW from recommending indexes. Some examples of what the ITW will not tune are:
* Primary key constraints and unique indexes
* Cross-database queries
* Queries with temporary tables or system tables
* Tables with less than 10 pages allocated