Overview
These best practices are written by experienced database engineers.
Partitioning
Fast analytics in StarRocks begin with a table layout that matches your query patterns.
Table clustering
A thoughtful sort‑key is the highest‑leverage physical‑design knob in StarRocks.
Bucketing
A concise field guide to choosing between Hash Bucketing and Random Bucketing in StarRocks, including their mechanics, trade‑offs, and recommended use cases.
Primary Key tables
The Primary Key table uses a new storage engine designed by StarRocks.
Audit Log-based Resource Group Configuration
In StarRocks, **Resource Groups** provide an effective mechanism for resource isolation by allocating CPU, memory, and concurrency limits based on classifiers such as user identity and query type.
Query Tuning
8 items
FE / Coordinator Node memory full issue troubleshooting
Prevent 'FE memory full' issues, quickly recover, and find out the cause as much as possible to prevent recurrence.