FIX: Optimizer Hint for Index Name Fails in View

ID: Q134823

The information in this article applies to:

Microsoft SQL Server, version 6.0

BUG# NT: 10266 (6.00)

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          : kbprg SSrvProg SSrvTran_SQL kbbug6.00 kbfix6.00.sp1 
Version           : 6.0
Platform          : WINDOWS

Last Reviewed: May 1, 1997