Microsoft KB Archive/134823

{|
 * width="100%"|

FIX: Optimizer Hint for Index Name Fails in View

 * }

Q134823

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

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