Materialised View
/məˈtɪəriəlaɪzd vjuː/
Definition
A database view whose result is pre-computed and stored, refreshed periodically — faster reads at the cost of staleness.
Example in context
"The analytics materialised view refreshes nightly — real-time data isn't needed and the join is expensive."
Related terms
Practice this term
Master Materialised View in context by working through exercises in the Databases & SQL module. You'll see the term used in real engineering scenarios with multiple-choice, fill-in-the-blank, and matching drills.