Performance Tuning Guide

10.5.7
- 10.5.8
- 10.5.6
- 10.5

Back Next

Configuring the Optimizer Level for Deployed SQL Data Services

Configure the optimizer level that the Data Integration Services uses to execute SQL queries against a deployed SQL data service. You can choose to override the optimizer level for a single query by configuring the optimizer level in the SQL data service connection.

In the Administrator tool, select a Data Integration Service.

Click the

Applications

view.

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

Select the SQL data 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 optimizer level that the Data Integration Services uses to execute a query, append the following entry to the JDBC URL or ODBC connection string:

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

Configuring the Optimizer Level for Deployed SQL Data Services

Configuring the Optimizer Level for Deployed SQL Data Services