[jacques_chester]

Dumb question: was the data ETL'd into a star schema first? That can make a big difference, especially in columnar stores.

[bloomfilter]

We sort of made it a partial star schema, but not strictly. since random join can be expensive