What is Materialized View

Definition

A materialized view is a database object that stores the precomputed results of a query physically, so repeated access returns the saved results instantly instead of recomputing them, with the view refreshed periodically or incrementally to stay current.

« Back to Glossary Index

Returns expensive aggregate results instantly from precomputed storage
Offloads heavy repeated computation from every query to a single refresh
Supports incremental refresh so only changed data is recomputed
Speeds dashboards and reports that hit the same complex query repeatedly

Real World Example

A BI team creates a materialized view of daily sales by region, so the executive dashboard reads the precomputed summary instantly each morning rather than re-aggregating billions of transaction rows on every load.

FAQs

How does a materialized view differ from a regular view?

A regular view recomputes its query each time it is accessed, while a materialized view stores results physically and returns them without recomputation.

How does a materialized view stay current?

It is refreshed on a schedule or incrementally as underlying data changes, trading some freshness for query speed.

When should you use a materialized view?

When the same expensive query runs repeatedly and slightly stale results are acceptable in exchange for fast response.