🎁 New User? Get 20% off your first purchase with code NEWUSER20 · ⚡ Instant download · 🔒 Secure checkout Register Now →
Menu

Categories

Databases Intermediate

What is Materialized View?

A database object that stores the precomputed result of a query, offering faster reads at the cost of periodic refresh.

Unlike regular views that execute their query each time they are accessed, materialized views store query results physically on disk. This dramatically speeds up complex aggregations, joins, and analytical queries. The trade-off is data freshness — materialized views must be refreshed (manually or on schedule) to reflect underlying table changes. PostgreSQL supports REFRESH MATERIALIZED VIEW with a CONCURRENTLY option for zero-downtime refreshes. They are invaluable for dashboards, reports, and read-heavy workloads where slight data staleness is acceptable.

Related Terms

CTE (Common Table Expression)
A temporary named result set defined within a SQL statement using the WITH clause, improving query readability and enabling recursion.
Query Optimization
The process of improving database query performance through indexing, query rewriting, and schema design techniques.
NoSQL
A category of databases that store data in non-tabular formats, optimized for specific data models and access patterns.
ORM (Object-Relational Mapping)
A technique that lets you interact with a database using object-oriented code instead of writing raw SQL queries.
JSONB
PostgreSQL's binary JSON data type that stores JSON documents with indexing, querying, and manipulation capabilities.
Prepared Statement
A pre-compiled SQL template that uses parameters instead of literal values, preventing SQL injection and improving performance.
 View All Databases Terms →