Lilly Schoen: Created page with "{{GlossaryTermTemp |SubtermOf=view, table |Definition=1. A materialized view is defined as a table which is actually physically stored on disk, but is really just a view of ot..."

2017-11-03T09:18:14Z

Created page with "{{GlossaryTermTemp |SubtermOf=view, table |Definition=1. A materialized view is defined as a table which is actually physically stored on disk, but is really just a view of ot..."

New page

{{GlossaryTermTemp
|SubtermOf=view, table
|Definition=1. A materialized view is defined as a table which is actually physically stored on disk, but is really just a view of other database tables. In PostgreSQL, like many database systems, when data is retrieved from a traditional view it is really executing the underlying query or queries that build that view.
2. A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table. Using materialized views against remote tables is the simplest way to achieve replication of data between sites.
|Sources=http://www.revsys.com/blog/2006/jan/03/when-to-use-a-materialized-view-in-postgresql/ (1.); https://oracle-base.com/articles/misc/materialized-views (2.)
}}
Author: Tim Röder

Materialised view - Revision history

Lilly Schoen: Created page with "{{GlossaryTermTemp |SubtermOf=view, table |Definition=1. A materialized view is defined as a table which is actually physically stored on disk, but is really just a view of ot..."