CREATE TABLE bf_performance_test
(
    `order_key` Int64, 
    `bf_index` String, 
    `other_column_1` UInt64, 
    `other_column_2` UInt32, 
    `other_column_3` String, 
    `other_column_4` Float64, 
    INDEX idx bf_index TYPE bloom_filter GRANULARITY 1
)
ENGINE = MergeTree
ORDER BY order_key
SETTINGS index_granularity = 8192;

INSERT INTO bf_performance_test SELECT 
    number AS order_key, 
    toString(number) AS bf_index, 
    number AS other_column_1, 
    toUInt32(number) AS other_column_2, 
    toString(number) AS other_column_3, 
    toFloat64(number) AS other_column_4
FROM system.numbers 
LIMIT 1000000000;

SELECT COUNT()
FROM bf_performance_test;

┌────COUNT()─┐
│ 1000000000 │
└────────────┘

1 rows in set. Elapsed: 2.652 sec. Processed 1.00 billion rows, 4.00 GB (377.10 million rows/s., 1.51 GB/s.) 



SELECT *
FROM bf_performance_test 
WHERE bf_index = '200000';

┌─order_key─┬─bf_index─┬─other_column_1─┬─other_column_2─┬─other_column_3─┬─other_column_4─┐
│    200000 │ 200000   │         200000 │         200000 │ 200000         │         200000 │
└───────────┴──────────┴────────────────┴────────────────┴────────────────┴────────────────┘

1 rows in set. Elapsed: 2.867 sec. Processed 23.61 million rows, 422.31 MB (8.24 million rows/s., 147.31 MB/s.)