Indexed Views/Materialized Views/NOEXPAND
An indexed view is a view with a unique clustered index created on it. It is also called Materialized View. If a query contains references to columns that are present both in an indexed view and base tables, and the query optimizer determines that using the indexed view provides the …