What is a materialised view?
Model answer
A view whose result is stored physically and refreshed on demand or on a schedule, so heavy aggregates are fast to read. The cost is stale data between refreshes and the refresh work. Support and refresh behaviour differ across databases.
Learn this topic
Subqueries, EXISTS and CTEs: Queries Inside Queries in the course SQL for Beginners: Learn Databases Step by Step.
Sign in to add your own answer.