Will TiDB non-unique index queries scan all SST files filtered by RocksDB Bloom filters?

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiDB非唯一索引查询,会扫描rocksdb 布隆过滤器过滤后的所有sst文件吗?

| username: TiDBer_C33

Will a TiDB non-unique index query scan all SST files filtered by the RocksDB Bloom filter? According to the course, each SST in each level is ordered.

| username: TiDBer_C33 | Original post link

Oh, each level is also ordered.

| username: xfworld | Original post link

Apart from the L0 level being a mapping of the Immutable MemTable, which is unnecessary to satisfy sequential writes, other levels will ensure order during Compaction merging.

The L0 level is quite special because there is corresponding data in memory, making retrieval very fast.