StarRocks Query Optimization

Tune StarRocks query performance: execution plans, partition pruning, JOIN strategy, predicate pushdown, parallelism, index usage, and slow-query diagnosis.

When to Use

• A StarRocks query is slow and needs diagnosis
• Reading and interpreting EXPLAIN / EXPLAIN VERBOSE / EXPLAIN ANALYZE
• Verifying partition pruning is active
• Choosing or hinting a JOIN strategy
• Tuning parallelism or index usage
• Analyzing a query profile to find the bottleneck

Related skills: [starrocks-table-design] for partitioning/bucketing/indexes that drive these plans; [starrocks-materialized-views] for pre-aggregation; [starrocks-monitoring] for processlist and killing queries.

Understanding EXPLAIN