📄️ Asynchronous materialized views
This topic describes how to understand, create, use, and manage an asynchronous materialized view. Asynchronous materialized views are supported from StarRocks v2.4 onwards.
📄️ Related References
- CREATE MATERIALIZED VIEW
🗃️ Use cases
4 items
📄️ Troubleshooting asynchronous materialized views
This topic describes how to examine your asynchronous materialized views and solve the problems you have encountered while working with them.
📄️ Feature Support
Asynchronous materialized views are supported from StarRocks v2.4 onwards. Asynchronous materialized views are designed to accelerate complex queries with joins or aggregations on large tables within StarRocks or in data lakes. The performance difference can be significant when a query is run frequently or is sufficiently complex. Additionally, asynchronous materialized views are especially useful for building mathematical models upon your data warehouse.