a local copy of a local or remote master table that reflects a recent state of the master table
a precomputed result that may be used to compute part or all of query instead of computing it from base tables
a precomputed table comprising aggregated and joined data from fact and possibly from dimension tables
a set of query results stored in a table
a stored summary containing precomputes results (originating from an SQL select statement)
a table that stores derived data
a technique to "cache" the results of a query when its result set is large or the query is very slow and that query is used very often
a view that is stored physically in the database
A Materialized View is a summary mechanism used by the Oracle 8.1.6+ server. Materialized Views pre-compute and store aggregated data for use in SQL queries.
A materialized view is a summary mechanism used by Oracle 8.1.7 (or later) Enterprise Edition databases. materialized views pre-compute and store aggregated data for use in SQL queries.
(SQL) A view that creates and stores a result table in advance of being used. views.php
A pre-computed table comprising aggregated or joined data from fact and possibly dimension tables. Also known as a summary or aggregate table.
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.
