Introduction to Query Tuning
Query tuning is essential for achieving high performance and reliability in StarRocks.
Query plan
Optimizing query performance is a common challenge in analytics systems.
Query Profile Overview
Query Profile records execution information for all working nodes involved in a query, helping you quickly identify bottlenecks affecting query performance.
Query Tuning Recipes
Query tuning recipes for StarRocks: symptom-to-fix playbook using query profiles to diagnose slow operators, skew, spill, and join issues.
Schema Tuning Recipes
This document provides practical tips and best practices for optimizing query performance in StarRocks through effective schema design and foundational table choices.
Explain Analyze
This document explains how to obtain and analyze text-based Query Profiles in StarRocks.
Query Hint
Query hints are directives or comments that explicitly suggest the query optimizer on how to execute a query.
Query Profile Metrics
Reference for all raw metrics emitted by StarRocks Query Profile, organized by operator type.