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.
Automatic Materialized View Recommendation
This topic describes how to leverage the Automatic Materialized View Recommendation feature to generate schemas for materialized views that can be used to accelerate the queries in your business scenarios.
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.
Understand Materialized View Task Runs
The information of materialized view refresh task runs can help understand materialized view refresh behavior, troubleshoot issues, and monitor performance.