Experience Enhancements

AnalyticDB for MySQL - Materialized views whose base tables are partitioned tables support fast refresh.

The incremental refresh capability of materialized views is optimized. You can perform operations such as INSERT OVERWRITE on base tables by partition table.
Content

Optimized content: You can incrementally refresh materialized views whose base tables are partition table. You can execute INSERT OVERWRITE and TRUNCATE statements on the base tables that are incrementally refreshed.

Help Document

https://www.alibabacloud.com/help/analyticdb/analyticdb-for-mysql/developer-reference/refresh-materialized-views?spm=a2c63.p38356.help-menu-92664.d_5_0_5_1.6b7e16efw14hz8

7th Gen ECS Is Now Available

Increase instance computing power by up to 40% and Fully equipped with TPM chips.
Powered by Third-generation Intel® Xeon® Scalable processors (Ice Lake).

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.