What are Indexed Views inside SQL Server ?

Views are a description of the data(metadata). When a view is a reference in the FROM clause its metadata is retrieved from the system catalog and placed into query. While working with a non-indexed view, the portion of the view is resolved at run time.

In the case of the Index view, the view's result set is materialized immediately and persisted in physical storage in the database. During the run time this materialized storage is used to resolve the query result. Index view is primary created expecting performance improvement from the query which uses that index.



You May Interest

What is Utility Control Point (UCP) in SQL Server ?

Getting Rows in a Table in Random Order in MS SQL

What is an Index in SQL Server ?

Using Trim Function in MS SQL

List of Table Columns Used in Any View in MS SQL