Indexed Views

Question

Indexed Views

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

SQL-DBA Hall of Fame Points: 3051 More actions · Answer 1

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

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.

http://support.microsoft.com/kb/270054/en-us

Laurence Neville SSC Eights! Points: 889 More actions · Answer 2

Thanks, I worked that out eventually!

This article is good for understanding indexed views, plus it has a section on "Using Indexed Views On Non Enterprise Editions of SQL Server":

http://www.novicksoftware.com/Articles/Indexed-Views-Basics-in-SQL-Server.htm