A view that stores a query's result as an actual copy, letting it be read back quickly.
A view that stores a query's result as an actual copy. Reads are fast, but it needs to be refreshed to keep up with changes to the underlying data. It typically isn't refreshed automatically the instant the underlying data changes -- an explicit operation like REFRESH MATERIALIZED VIEW or a scheduled batch job updates it instead, and how often that runs is a tradeoff between data freshness and processing load.
© 2026 ITBGM