Materialized view is one of the core features in the data warehouse field. Materialized views retain the query results of views, which is different from logical views.
You can perform the following operations on materialized views:
- Create materialized views
- Refresh materialized views
- Manage materialized views
- Query materialized views
Materialized views can be used to accelerate analysis and simplify extract, transform, and load (ETL) operations. Materialized views are applicable to multiple scenarios, such as report business, dashboard display, and queries from BI tools.
For more information about customer stories of materialized views, see Customer stories of materialized views.