Microsoft KB Archive/69020

INF: Creating Indexes on Views Not Allowed

PSS ID Number: Q69020 Article last modified on 12-18-1992

1.10 1.11 OS/2

Summary: Page 214 of the “Microsoft SQL Server Learning TRANSACT_SQL” manual for versions 1.1 and 1.11 incorrectly states that you can build an index on a view. Trying to do this results in the following error message: Msg: 1914, Level 16, State 1: Cannot create index on object ‘your_view’ because it is not a user table. This type of usage is not allowed, nor are there any plans to allow this type of functionality in the future. However, if the underlying tables have indexes on them, they can be used, depending on how the view was created. The SQL Server version 4.2 “Transact-SQL User’s Guide” has been updated to correct this documentation error. Two other articles in the knowledge base contain more information about SELECT statements that will be using indexes. For more information, query on the following words: vector and efficient and SQL Server

= Additional reference words: Transact-SQL =

Copyright Microsoft Corporation 1992.