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

Article translations Article translations
Article ID: 270054 - View products that this article applies to.
This article was previously published under Q270054
Expand all | Collapse all


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 SQL Server 2000, the benefits in performance can be obtained only in the Enterprise 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:

SQL Server 2000 Books Online (Updated)


Article ID: 270054 - Last Review: October 16, 2003 - Revision: 3.3
  • Microsoft SQL Server 2000 Standard Edition
kbpending kbprb kbsqlserv2000sp1fix KB270054

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from