Answer
A materialized view stores the result of a query as a database object. • Its stored data can make repeated reads faster. • The result can become stale until it is refreshed. • Refresh behavior and concurrency options are database-specific.
💡 SQL Example
CREATE MATERIALIZED VIEW department_totals AS SELECT department_id, COUNT(*) AS total FROM employees GROUP BY department_id;
Result
SELECT 2
⚡ Quick Revision
A materialized view stores query results and needs refreshing.