Summary
A materialized view is a database object that contains the results of a query, such as a local copy of data located remotely, a subset of the rows and/or columns of a table or join result, or a summary using an aggregate function.
1
When a materialized view is referenced in a query, the data is returned directly from the materialized view, like from a table.
2
According to
See more results on Neeva
Summaries from the best pages on the web
Summary
In computing , a materialized view is a database object that contains the results of a query . For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary using an aggregate function
Materialized view - Wikipedia
wikipedia.org
Summary
So for the parser, a materialized view is a relation, just like a table or a view. When a materialized view is referenced in a query, the data is returned directly from the materialized view, like from a table; the rule is only used for populating the materialized view.
PostgreSQL: Documentation: 12: 40.3. Materialized Views
postgresql.org
Use the CREATE MATERIALIZED VIEW statement to create a materialized view . A materialized view is a database object that contains the results of a query. The ...
CREATE MATERIALIZED VIEW
oracle.com
ORACLE-BASE - Materialized Views in Oracle ... A materialized view, or snapshot as they were previously known, is a table segment whose contents are ...
ORACLE-BASE - Materialized Views in Oracle
oracle-base.com
TL;DR: Querying materialized views, unlike querying tables or logical views, can reduce query costs by maintaining results in memory that are only updated when ...
Why Use a Materialized View? - Materialize
materialize.com
