This suggestion ultimately solved the problem of the long Query runtime.
BAQ with date range of 06/01/2020 - 06/30/2020. 25 records that represent all the days we shipped something. With 8 inline subquery calculated fields.
Run without any company criteria. Non Cross Company BAQ
13.683 minutes
Run with company hardcoded company = ‘abcdef’ on all tables marked with 1 including inline subqueries
3.45 minutes
Run with BAQ Special Constant of CurComp on all tables marked with a 1 including inline subqueries
0.167 minutes
I guess i just want to deny the findings of this whole thread