materialized view

Definitions

1. A database object that stores the precomputed results of a query physically on disk, unlike a regular view which re-executes the query each time. Materialized views dramatically speed up expensive aggregate queries but introduce staleness — the stored results must be periodically refreshed to reflect changes in the underlying tables.

   In plain English: A saved copy of a query's results that the database keeps on hand so it doesn't have to recalculate the answer every time you ask.

   Example: We created a materialized view for the daily revenue report and set it to refresh every 15 minutes — the dashboard went from timing out to loading instantly.

Related Terms

• B-tree
• query planner
• index
• Jemalloc
• Memory Arena
• Query Optimizer
• RocksDB
• Row-Level Security
• Shared Nothing Architecture
• Static Dispatch
• Write Concern