Article ID: 290414 - View products that this article applies to.
This article was previously published under Q290414
BUG #: 235118 (SHILOH_BUGS)
After successfully running the Index Tuning Wizard, the hypothetical clustered indexes, whose names start with "hind", may be left behind in the database.
To resolve this problem, obtain the latest service pack for SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/ )How to obtain the latest SQL Server 2000 service pack
To work around this behavior:
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
The query optimizer will not use the hypothetical indexes that are left behind. Therefore, these hypothetical indexes will not cause you to obtain a bad query plan.
However,if you leave the hypothetical indexes behind, the statement or procedure might recompile several times and affect performance. Additionally, leaving the hypothetical indexes may negatively affect the quality of recommendations from later runs of the Index Tuning Wizard because there is a limit to the number of hypothetical indexes that can be created per table. Therefore, you must drop these hypothetical indexes.
For more information about a related issue, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/293177/ )BUG: Hypothetical clustered index from Index Tuning Wizard may cause recompile loop
Contact us for more help
Connect with Answer Desk for expert help.