Avatar

Correct answer by
Community Advisor

Hi,

 

You can control join order by breaking up joins and doing them one at a time with enrichments.

I've done this in Postgres to reduce query time from 30+ seconds to sub-second.

 

Thanks,

-Jon

View solution in original post