FIX: Optimizer Hint for Index Name Fails in View

Q134823

The information in this article applies to:

SYMPTOMS

When you create a view using an optimizer hint to force an index and the index is specified by the index name, a query on that view fails with the following error:

Msg 308, Level 16, State 1
Index '%s' on table '%s' (specified in the FROM clause) does not exist.


CAUSE

Microsoft SQL Server version 6.0 incorrectly interprets the optimizer hint as an index name within a view.


WORKAROUND

In the optimizer hint, specify the index using the index id instead of the index name when you create the view. The index id can be obtained by querying the sysindexes system table.


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: query plan

Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600


Last Reviewed: March 25, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.