查询调优最佳实践

📄️ 查询调优简介

Query tuning in StarRocks follows a top-down process: identify problems, analyze query plans, and apply optimization techniques for high performance.

Query plans describe how SQL statements execute in StarRocks, breaking down queries into operations like scan, join, aggregate, and sort.

Query Profile records execution information for all working nodes in a query, helping identify bottlenecks affecting query performance.

Symptom-to-fix playbook using StarRocks query profiles to diagnose and resolve slow operators, data skew, spill, and join issues.

Best practices for optimizing StarRocks query performance through schema design, table type selection, and sort key configuration.

Obtain and analyze text-based Query Profiles in StarRocks using EXPLAIN ANALYZE to diagnose slow query execution and find optimization opportunities.

Query hints are directives that explicitly suggest the query optimizer on how to execute queries, including SET_VAR and Join hints.

StarRocks Query Profile发出的所有原始指标的参考，按操作符类型组织。