A materialized view is a database object that contains the results of a query. They are local copies of data LOCATED remotely, or are used to create summary tables BASED on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots. A materialized view caches the query result as a concrete table that may be updated from the original base tables from time to time. Materialized views were implemented first by the ORACLE database. In IBM DB2, they are called “materialized query tables”; Microsoft SQL SERVER has a similar FEATURE called “indexed view”.

A materialized view is a database object that contains the results of a query. They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots. A materialized view caches the query result as a concrete table that may be updated from the original base tables from time to time. Materialized views were implemented first by the Oracle database. In IBM DB2, they are called “materialized query tables”; Microsoft SQL Server has a similar feature called “indexed view”.