Performance Tuning Guide

10.5.8
- 10.5.7
- 10.5.6
- 10.5

Back Next

Optimizer Levels

The Data Integration Service optimizes mappings based on the optimizer level that you configure. Configure the optimizer level property when you want the mapping to use an optimizer level other than the default.

You can choose one of the following optimizer levels:

Auto: The Data Integration Service applies optimizations based on the execution mode and mapping contents.
None: The Data Integration Service does not apply any optimization.
Minimal: The Data Integration Service applies the early projection optimization method.
Normal: The Data Integration Service applies the early projection, early selection, branch pruning, push-into, global predicate optimization, and predicate optimization methods.
Full: The Data Integration Service applies the cost-based, early projection, early selection, branch pruning, predicate, push-into, semi-join, and dataship-join optimization methods.

Default is Auto.

When you run the mapping from the

Run

menu or mapping editor in the Developer tool, the Data Integration Service applies the optimizer level in the mapping configuration. When you run the mapping from the command line, the Data Integration Service applies the optimization level from the mapping deployment properties in the application.

The Data Integration Service does not apply the pushdown optimization method with an optimizer level. You can configure pushdown optimization for a mapping in the mapping run-time properties.

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

Optimizer Levels

Optimizer Levels