Bellow is the post I made on other discussion, with my problem with more details: Hello, Ben_Vandiver! I'm having a similar problem here. I have a fact table with millions of registers with some dimensions. And I need to improve a performance of a query, initially I was trying to create a projection...

was asking in a other discussion but since there is no discussion focused on Prejoin Projection and the replacement for this since v8.1 Flattened Tables, I created this one. Basically, what is the best practice to improve the performance of a query with joins in the V9.X? Before V8.1, we would creat...