Materialized view

Applies to: sql

A materialized view stores the result of a query physically, trading freshness and storage for faster reads.

REFRESH MATERIALIZED VIEW monthly_revenue;

See also: view, index