SQL 67 🛢️ Materialized Views and Refresh Strategies
A regular view is a stored query. Every time it is referenced, the database re-executes the query against the underlying tables. The result is always current, but the cost is paid on every read. A materialized view is a stored result. The query runs once, at the creation, and its output is written to disk…