StarRocks Materialized Views

Pre-aggregate and accelerate StarRocks queries with synchronous rollups and asynchronous materialized views, including transparent query rewrite.

When to Use

• Repeated aggregations or joins that are expensive to recompute
• Building scheduled, refreshed summary tables
• Enabling transparent query rewrite so existing queries auto-use the MV
• Managing MV refresh and lifecycle

Type selection:

• Synchronous Rollup — simple pre-aggregations, automatically maintained
• Asynchronous MV — complex transformations, joins, scheduled refresh

Related skills: [starrocks-query-optimization] for when to reach for an MV vs other tuning; [starrocks-etl-and-tasks] for SUBMIT TASK-based refreshes.

Synchronous Rollup (Automatic)