Asynchronous materialized views
Incremental Materialized Views
How to create, use, refresh, and monitor incremental materialized views on native tables, for fresh results at delta-sized refresh cost.
Asynchronous materialized views
How to create, use, refresh, and manage asynchronous materialized views in StarRocks for accelerating multi-table join and aggregation queries with...
Related References
Reference index for asynchronous materialized view SQL statements (CREATE, ALTER, REFRESH, DROP) and system views for monitoring in StarRocks.
Use cases
4 items
Troubleshooting asynchronous materialized views
Troubleshooting guide for asynchronous materialized views in StarRocks: how to diagnose and fix refresh failures, query rewrite issues, and data consistency...
Automatic Materialized View Recommendation
Use a Tunespace to get recommended asynchronous materialized view schemas that accelerate your queries, and merge legacy materialized views.
Feature Support
Reference for feature support boundaries of asynchronous materialized views in StarRocks: supported join types, aggregate functions, query rewrite...
Understand Materialized View Task Runs
How to view and interpret materialized view refresh task run details in StarRocks to understand refresh behavior, troubleshoot failures, and monitor refresh...