CREATE TABLE t2(x,y); CREATE TABLE t1(x,y); CREATE INDEX i2 on t2(x); insert into t1(x,y) select value, hex(randomblob(8)) from generate_series(1,10000); insert into t2(x,y) select value, hex(randomblob(8)) from generate_series(1,100); analyze; explain query plan select * from t1,t2 where t1.x = t2.x and t2.y like ?; QUERY PLAN |--SCAN t1 |--BLOOM FILTER ON t2 (x=?) `--SEARCH t2 USING INDEX i2 (x=?)