StarRocks Table Design

Design table schemas for StarRocks (a sub-second MPP OLAP database): table types, partitioning, bucketing/distribution, and indexing.

Reference: StarRocks Partitioning Best Practices

When to Use

• Creating or modifying a StarRocks table schema
• Choosing a key model (Duplicate / Aggregate / Unique / Primary Key)
• Deciding partition strategy and granularity
• Sizing bucket counts and choosing the distribution key
• Selecting indexes for filter/lookup performance

Related skills: [starrocks-query-optimization] for verifying partition pruning and JOIN strategies; [starrocks-data-loading] for loading into the tables you design.

Table Types and DDL

Choosing the Right Table Type