intermediate~3h
Views — Simple View & Materialized View
Views let you name a complex query once so everyone reuses the same definition; materialized views take that a step further by physically storing the result, trading freshness for speed.
Learning objectives
- Explain what actually happens, internally, when a query runs against a view versus a materialized view.
- Decide correctly when a materialized view is worth the staleness it introduces, and when a simple view is enough.
- Set up a materialized view so it can be refreshed without blocking concurrent readers.
This is a Pro chapter
Sign in, then upgrade to Pro or Power to unlock this and the full Databases Mastery library.
Views — Simple View & Materialized View