Microsoft KB Archive/270054

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

Article ID: 270054

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q270054



SYMPTOMS
The &quot;Creating an Indexed View&quot; 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)

Additional query words: BOL

Keywords: kbsqlserv2000sp1fix kbprb kbpending KB270054

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.