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.

Example:

You have a query with some passes like:

Pass1

 Pass2

  Pass3

   Pass4

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

pic

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:

WordPress.com Logo

You are commenting using your WordPress.com 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