Purpose

Specifies the Db2 optimization profile that is used during SQL optimization. The optimization profile contains optimization guidelines that are passed to Db2 to influence the generation of query plans. This property sets the value of the Db2 OPTIMIZATION PROFILE special register.

This property only applies to Db2 for Linux/UNIX/Windows.

Valid Values

profile_name

where:

profile_name
is the name of a valid Db2 optimization profile.

Data Source Methods

public String getOptimizationProfile()

public void setOptimizationProfile(String)

Default

null

Data Type

String

See also

Performance considerations