Open Access Open Access  Restricted Access Subscription or Fee Access

Overview of Query Materialization

Priyanka M. Yalagach, Kavitha G., Mohammad Rafi



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

Full Text:



  • There are currently no refbacks.

This site has been shifted to