Microsoft® SQL Server 2012 Unleashed

Indexed Views

As discussed in Chapter 23, “Creating and Managing Views,” SQL Server 2012 allows you to create indexed views. An indexed view is any view that has a unique clustered index defined on it. When a CREATE INDEX statement is executed on a view, the result set for the view is materialized and stored in the database with the same structure as a table with a unique clustered index. Changes made to the data in the underlying tables of the view are automatically reflected in the view the same way any changes to a table are reflected in its indexes. In addition to the unique clustered index, you can create additional nonclustered indexes on indexed views to provide additional query performance. Additional indexes on views might provide more ...