Intermediate
SQL
Q71 / 100
What is a "materialized view" and how does it differ from a regular view?
Correct! Well done.
Incorrect.
The correct answer is B) A materialized view physically stores (caches) the query result on disk and must be refreshed periodically, while a regular view is computed on-the-fly each time it is queried
B
Correct Answer
A materialized view physically stores (caches) the query result on disk and must be refreshed periodically, while a regular view is computed on-the-fly each time it is queried
Explanation
Materialized views trade storage and freshness (requiring REFRESH) for faster read performance, since the result set is precomputed and stored rather than recalculated on each query.
Progress
71/100