ποΈ Catalogs, databases, and tables
Overview of StarRocks catalog, database, and table organization: internal vs external catalogs, database objects including tables, materialized views, and views.
ποΈ Table overview
Overview of StarRocks table design principles: columnar storage, sort keys, data organization, and how to structure tables for optimized query performance.
ποΈ Table types
5 items
ποΈ Data distribution
5 items
ποΈ Data compression
How to configure data compression in StarRocks using LZ4, Zstandard, zlib, or Snappy algorithms to reduce storage space and improve I/O performance.
ποΈ Indexes
7 items
ποΈ Hybrid row-column storage
How to use hybrid row-column storage in StarRocks (from v3.2.3) for high-concurrency point queries and partial column updates alongside efficient analytical queries.
