MicroStrategy ONE

Parallel Query Execution Improvement Estimate in SQL View

Parallel Query Execution Improvement Estimate in SQL View is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The Parallel Query Execution Improvement Estimate in SQL View property determines whether reports and Intelligent Cubes include an estimate in the percent of processing time that would be saved if parallel query execution was used to run multiple queries in parallel. This VLDB property has the following options:

  • Disable parallel query execution estimate in SQL view: An estimate on the percent of processing time that would be saved if parallel query execution was used for the report or Intelligent Cube is not displayed in the SQL view of the report. This can simplify the SQL view if you are already using parallel query execution or you are not interested in this estimated improvement.
  • Enable parallel query execution estimate in SQL view: An estimate on the percent of processing time that would be saved if parallel query execution was used for the report or Intelligent Cube is displayed in the SQL view of the report. This estimate is provided as a percentage of time that could be saved by using parallel query execution.

    To calculate this estimate, the report or Intelligent Cube is analyzed to determine if there are multiple queries. If there are multiple queries, this estimate is calculated by assuming that all applicable queries are run in parallel.

    Be aware that this estimate does not factor in the capabilities of the database you are using, which can have an effect on the performance of parallel query execution since the database is what processes the multiple passes in parallel. Additionally, this estimate assumes that all queries that can be done in parallel are in fact performed in parallel. If parallel query execution is enabled, the number of queries that can be performed in parallel is controlled by the Maximum Parallel SQLs Per Report VLDB property (see Parallel Query Execution Improvement Estimate in SQL View).

Levels at Which You Can Set This

Project only