What is a materialised view?
- A A stored, precomputed query result that is refreshed periodically
- B A virtual table evaluated at query time
- C A backup of a table
- D An index on multiple columns
Answer
A stored, precomputed query result that is refreshed periodically
It trades storage and refresh cost for query speed, which suits expensive aggregations queried far more often than the data changes.





