CSE Roadmap

Common tier · about 2 hours · 5 parts

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.