Microsoft KB Archive/278274

= PRB: Index Tuning Wizard Does Not Suggest Proper Index When There Is Not Enough Space =

Article ID: 278274

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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.

Additional query words: index

Keywords: kbprb KB278274

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.