Performance Tuning Guide

10.5.7
- 10.5.8
- 10.5.6
- 10.5

Back Next

Web Service Optimizer Level

The Data Integration Service optimizes web services based on the optimizer level that you configure. Configure the optimizer level when you want the web service to use an optimizer level other than the normal. By default, each web service uses the normal optimizer level.

You can choose one of the following optimizer levels:

0 (None): The Data Integration Service does not apply any optimization.
1 (Minimal): The Data Integration Service applies the early projection optimization method.
2 (Normal): The Data Integration Service applies the early projection, early selection, branch pruning, push-into, global predicate optimization, and predicate optimization methods.
3 (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.