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


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q270054

SYMPTOMS

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.

MORE INFORMATION

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)

Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbpending kbprb kbSQLServ2000sp1fix KB270054
©2003 Microsoft Corporation. All rights reserved.