Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Explain how a materialized view differs from an ordinary view.
- Explain what it means to refresh a materialized view, and name common refresh strategies.
- Explain the storage-for-speed trade-off a materialized view makes.
- Decide when a materialized view is a good fit for an expensive, frequently run query.
This level has covered many ways to make a given query run faster: better join algorithms, better indexes, sargable conditions, efficient pagination. This closing page covers a different approach entirely. Skip running the expensive query altogether, most of the time, by precomputing its result in advance.