📄️ Gather statistics for CBO

This topic describes the basic concept of StarRocks CBO and how to collect statistics for the CBO. StarRocks 2.4 introduces histograms to gather accurate data distribution statistics.

📄️ Bitmap indexes

This topic describes how to create and manage a bitmap index, along with usage cases.

📄️ Synchronous materialized view

This topic describes how to create, use, and manage a synchronous materialized view (Rollup).

📄️ Bloom filter indexing

This topic describes how to create and modify bloom filter indexes, along with how they works.

🗃️ Asynchronous materialized views

5 items

📄️ Colocate Join

For shuffle join and broadcast join, if the join condition is met, the data rows of the two joining tables are merged into a single node to complete the join. Neither of these two join methods can avoid latency or overhead caused by data network transmission between nodes.

📄️ Use Lateral Join for column-to-row conversion

Column-to-row conversion is a common operation in ETL processing. Lateral is a special Join keyword that can associate a row with an internal subquery or table function. By using Lateral in conjunction with unnest(), you can expand one row into multiple rows. For more information, see unnest.

🗃️ Caching

2 items

🗃️ Computing the number of distinct values

2 items

📄️ Sorted streaming aggregate

Common aggregation methods in database systems include hash aggregate and sort aggregate.

📄️ Accelerate Cardinality-Preserving Joins

This topic describes how to accelerate cardinality-preserving joins with table pruning. This feature is supported from v3.1 onwards.