There is a excellent vldb option to execute in parallel independent sql passes.So. if you have more than one pass in your SQL and those aren’t dependent, you can instruct Microstrategy to execute them separately. Microstrategy will open DB connections to execute those SQLs.
You have a query with some passes like:
If Pass1 isn’t dependent of Pass2, Microstrategy will execute them separately.
To do that, you just have to:
1. Open your report;
2. Click on Data -> VLDB Properties
3. Select Query Optimization -> Parallel Query Execution
Justchoose one of those 2 “Enable” options. Just read it and see which one is better for you.
Hope it helps!
God bless you!