skip to main content
DataDirect Connect Drivers : DB2 Driver : Connection Properties : OptimizationProfile
  
OptimizationProfile
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 V9.1 and higher for Linux/UNIX/Windows.
Valid Values
profile_name
where:
profile_name
is the name of a valid DB2 optimization profile.
Default
null
Data Type
String
See also
Performance Considerations