Start of change

OPTIOPIN in macro DSN6SPRM

Controls whether DB2® is to use an enhancement to more accurately estimate the cost of accessing the inner table of a join that involves index and data access. This enhancement removes an inconsistency with the calculation of the cost for the outer table of a join.

With this subsystem parameter enabled, DB2 has a better chance to select more efficient access paths. Valid values are ENABLE and DISABLE.

ENABLE specifies DB2 is to use the costing enhancement. This setting is recommended for new installations or migrations.

DISABLE specifies that DB2 is not to use the costing environment.

ENABLE is the default value.

This subsystem parameter is deprecated in DB2 10.

End of change