O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating an Indexed View

In addition to making data modifications through a view, you can also create an index on a view.

When a regular view is created, SQL Server only stores the definition of the view, which is then substituted by the query optimizer for SELECT statements issued against the view.

An index is built against a list of values in a column. When you index a view, SQL Server executes the SELECT statement defined by the view, stores the result set, and then builds the index. Any subsequent DML issued against any of the tables the view is defined against will cause SQL Server to incrementally update the stored result set as well as maintain the index, if necessary. Because SQL Server physically stores and maintains the result set, or ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required