Tag: starrocks
A side-by-side look at how ClickHouse and StarRocks use Bloom filters: granules vs pages, tunable vs automatic indexes, text search, join runtime filters, and how to verify each. Plus a decision guide for when to use what.
How StarRocks uses Bloom filters in two very different places: page-level indexes stored on disk, and runtime filters built during joins. How to create them, verify them in the query profile, and know when they won't help.
A plain-language tour of StarRocks' storage hierarchy, from catalogs, partitions and tablets down to rowsets, segments and data pages, and how zone maps, bitmap indexes and bloom filters let queries skip most of the data without ever reading it.