PRB: Index Tuning Wizard Does Not Suggest Proper Index When There Is Not Enough Space (278274)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q278274

SYMPTOMS

When you use the Microsoft SQL Query Analyzer query selection functionality of the Index Tuning Wizard (ITW), the ITW may not recommend an appropriate index.

CAUSE

If the index requires more space than what is displayed in the Index Tuning parameters, the ITW does not recommend an index.

The Maximum space for the recommended indexes (MB) option is located under the Advanced Options tab in the Index Tuning Wizard.

NOTE: The Maximum space for the recommended indexes (MB) option specifies the maximum space in megabytes that can be consumed by the recommended index set. The default space is three times the current data size or the maximum available space on all attached disk drives, whichever is smaller.

WORKAROUND

If you suspect that this may be an issue, increase the value in the Maximum space for the recommended indexes (MB) option.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbprb KB278274
©2003 Microsoft Corporation. All rights reserved.