What is a 'Materialized View'?

Approach: Compare standard views with persisted query results.

A database object that contains the results of a query and stores them physically on disk. It is used to speed up heavy queries at the cost of storage and data freshness.

Follow-up: How do you keep it up to date?

Key concepts: caching, refresh, query speed.