Overview of Query Materialization

Abstract

Abstract

A materialized view (MV) is the pre-calculated (materialized) result of a query. Unlike a simple view, the result of a materialized view is stored somewhere, generally in a table. Materialized views are used when immediate response is needed and the query where the materialized view bases on would take too long to produce a result. Materialized views have to be refreshed once in a while. It depends on the requirements how often a materialized view is refreshed and how actual its content is. Basically, a materialized view can be refreshed immediately or deferred. It can be refreshed fully or to a certain point in time.

Keywords: Database, materialized view, view, oracle, query, SQL, ware-house