what materialized view and non Materialized view in sql server

Question

Manikavelu Velayutham · Answer

Materialized View - A materialized view takes a different approach in which the query result is cached as a concrete table that may be updated from the original base tables from time to time. This enables much more efficient access at the cost of some data being potentially out-of-date. It is most useful in data warehousing scenarios where frequent queries of the actual base tables can be extremely expensive. Non-Materialized View - A Non-Materialized view takes the output of a query and makes it appear like a virtual table. You can use a view in most places where a table can be used. All operations performed on a view will affect data in the base table and so are subject to the integrity constraints and triggers of the base table.