What is a Materialized View?
Materialized Views
Unlike virtual views that re-execute their query definition on every request, a Materialized View computes and stores the result set physically on disk.
Comparison
| Feature | Standard View | Materialized View |
|---|---|---|
| Physical Storage | Query definition only (0 bytes) | Physical disk storage |
| Read Performance | Same as underlying query | Extremely fast (cached scan) |
| Data Freshness | 100% real-time data | Point-in-time snapshot |
| Update Mechanism | Dynamic on read | REFRESH MATERIALIZED VIEW |