PRB: Indexed Views Can Be Created on All Versions of SQL Server 2000

This article was previously published under Q270054
This article has been archived. It is offered "as is" and will no longer be updated.
The "Creating an Indexed View" topic of SQL Server Books Online states that Indexed Views can only be created on the Microsoft SQL Server 2000 Enterprise edition and Microsoft SQL Server 2000 Developer edition.

That statement is incorrect.
You can create Indexed Views on all editions of SQL Server 2000.While it is possible to create indexed views in all editions of SQLServer 2000, the benefits in performance can be obtained only in theEnterprise and Developer edition of SQL Server 2000. This is because the Query Optimizer does not take the indexes on the views into consideration when generating an execution plan in other editions.To download an updated version of Microsoft SQL Server 2000 Books Online, visit the following Microsoft Web site:


Article ID: 270054 - Last Review: 01/16/2015 20:35:13 - Revision: 3.3

Microsoft SQL Server 2000 Standard Edition

  • kbnosurvey kbarchive kbpending kbprb kbsqlserv2000sp1fix KB270054