Core concept

CREATE MATERIALIZED VIEW ... AS SELECT. Refresh manual or incremental.

Advertisement

How it works

Refresh overhead. Rewriter limitations.

Advertisement

Trade-offs + gotchas

Repeated aggregation queries. BI dashboards.