Materialized View
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is a materialised view?
2. How does a materialised view differ from a regular view?
3. What does a materialised view represent in terms of timing?
4. Are materialised views automatically updated when the underlying data changes?
5. Which command updates a materialised view with the latest data from the underlying tables?
6. Why can materialised views significantly improve query performance?
7. For which scenario are materialised views described as particularly useful?
8. When are materialised views especially effective for aggregation and summary?
9. How might a regular view and a materialised view be used together in one application?
10. How is a materialised view queried once it has been created?