ποΈ View Running Queries
How to view and monitor running queries in StarRocks using current_queries and related views, analyze their resource consumption, and cancel long-running queries.
ποΈ Gather statistics for CBO
How to configure StarRocks' cost-based optimizer (CBO) by collecting full, sampled, and histogram statistics for internal and external tables to improve query plan accuracy.
ποΈ SQL Plan Manager
How to use SQL Plan Manager in StarRocks to bind a fixed query plan to a SQL statement, preventing plan changes from statistics or data updates and stabilizing query performance.
ποΈ Query Feedback
How to use Query Feedback in StarRocks to automatically analyze slow query plans, generate optimization guides via Query Plan Advisor, and improve subsequent query performance.
ποΈ Synchronous materialized view
How to create, use, and manage synchronous materialized views (Rollups) in StarRocks for transparent acceleration of single-table aggregate queries with automatic refresh.
ποΈ Asynchronous materialized views
6 items
ποΈ Colocate Join
How to use Colocate Join in StarRocks to perform joins locally without network data transmission by co-locating data from joined tables in the same Colocation Group.
ποΈ Use Lateral Join for column-to-row conversion
How to use Lateral Join with unnest() in StarRocks to convert array columns to rows (explode), commonly used in ETL pipelines for column-to-row transformation.
ποΈ Caching
2 items
ποΈ Computing distinct value count
2 items
ποΈ Sorted streaming aggregate
How to use sorted streaming aggregate in StarRocks (available from v2.5) to optimize GROUP BY queries on pre-sorted data, reducing memory overhead compared to hash aggregation.
ποΈ Accelerate COUNT(DISTINCT) and Joins with AUTO INCREMENT and Global Dictionary
How to use AUTO INCREMENT columns and Global Dictionary in StarRocks to replace string keys with integer IDs, accelerating COUNT(DISTINCT) and join operations.
ποΈ Flat JSON
How to use Flat JSON in StarRocks to accelerate JSON queries by extracting common fields from JSON columns into flat columnar storage, reducing parsing overhead.
ποΈ Accelerate Cardinality-Preserving Joins
How to use table pruning to accelerate cardinality-preserving joins in StarRocks by removing redundant joined tables that do not affect query results.
ποΈ JIT Compilation for Expressions
How to enable and configure JIT (just-in-time) compilation for expressions in StarRocks to accelerate expression evaluation in query execution.
ποΈ Skew Join V2
How to use Skew Join V2 in StarRocks to optimize JOIN queries with data skew by broadcasting skew values, improving performance for heavily skewed data distributions.
