Skip to main content
Version: Latest-3.5

Overview

These best practices are written by experienced database engineers.

General table design

Three guides covering:

Learn about:

  • The differences between partitioning and bucketing
  • When to partition
  • How to choose an efficient sort key
  • Choosing between hash and random bucketing

Primary key tables

The Primary Key table uses a new storage engine designed by StarRocks. Its main advantage lies in supporting real-time data updates while ensuring efficient performance for complex ad-hoc queries. In real-time business analytics, decision-making can benefit from Primary Key tables, which use the newest data to analyze results in real-time, mitigating data latency in data analysis.

Learn about:

  • Choosing the type of primary key index
  • Choosing the primary key
  • Monitoring and managing memory use
  • Tuning