1 2 3 4 5 6 7 8 9 10
QUERY PLAN [ MATERIALIZE a0 [ SCAN j0, SEARCH f0 USING INTEGER PRIMARY KEY (rowid=?), USE TEMP B-TREE FOR GROUP BY, ], SCAN j0, BLOOM FILTER ON a0 (ff0=?), SEARCH a0 USING AUTOMATIC COVERING INDEX (ff0=?) LEFT-JOIN, ]