Article ID: 270054 - View products that this article applies to.
This article was previously published under Q270054
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)
Contact us for more help
Connect with Answer Desk for expert help.