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.

Note Upgrade the engine to the latest version before you use materialized views. The version of the engine must be 3.1.3.4 or later. If the version of the engine is earlier than 3.1.3.4, contact the official support to upgrade. The DingTalk ID is x5v_rm8wqzuqf. For more information about how to view the engine version of a cluster, see How can I view the version of an AnalyticDB for MySQL cluster?.

You can perform the following operations on 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.