Parallel Query Execution

Hello there!

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!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s