Performance Tuning Guide

10.5.8
- 10.5.7
- 10.5.6
- 10.5

Back Next

Configuring the Optimizer Level for Deployed Web Services

Configure the optimizer level that the Data Integration Services uses to run a deployed web service. You can choose to override the optimizer level for a single request by configuring the optimizer level in the HTTP header of the web service SOAP request.

In the Administrator tool, select a Data Integration Service.

Click the

Applications

view.

Expand the application that contains the web service for which you want to configure the optimizer level.

Select the web service and edit the following property:

Property	Description
Optimization Level	The optimizer level that the Data Integration Service applies to the object. Enter the numeric value that is associated with the optimizer level that you want to configure. You can enter one of the following numeric values: 0. The Data Integration Service does not apply optimization. 1. The Data Integration Service applies the early projection optimization method. 2. The Data Integration Service applies the early projection, early selection, push-into, and predicate optimization methods. 3. The Data Integration Service applies the cost-based, early projection, early selection, push-into, predicate, and semi-join optimization methods.

Property

Description

Optimization Level

The optimizer level that the Data Integration Service applies to the object. Enter the numeric value that is associated with the optimizer level that you want to configure. You can enter one of the following numeric values:

0. The Data Integration Service does not apply optimization.

1. The Data Integration Service applies the early projection optimization method.

2. The Data Integration Service applies the early projection, early selection, push-into, and predicate optimization methods.

3. The Data Integration Service applies the cost-based, early projection, early selection, push-into, predicate, and semi-join optimization methods.

To override the web service optimization level for a web service request, include the following entry in the HTTP header of the web service SOAP request:

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

Configuring the Optimizer Level for Deployed Web Services

Configuring the Optimizer Level for Deployed Web Services