A stored summary or snapshot (remote materialized view used for replication) containing precomputed results. A CREATE MATERIALIZED VIEW statement containing a subquery, typically a join or a data aggregation, is used to create the materialized view. This provides much faster access to summary data. Local materialized views can be used for query rewrite.
A materialized view ( MV) is similar to a view but the data is actually stored on disk ( view that materializes). Materialized views are often used for summary and pre-joined tables, or just to make a snapshot of a table available on a remote system MV must be refreshed when the data in the underlying tables is changed.
A view is a virtual table representing the result of a database query. Whenever an ordinary view's table is queried or updated, the database management system converts these into queries or updates against the underlying base tables. A materialized view takes a different approach in which the query result is stored as a concrete table that is infrequently updated from the original base tables.