DB2 Version 9.7 for Linux, UNIX, and Windows

Cost model has been improved for queries in partitioned database environments

The optimizer's cost model has been enhanced to improve performance of some queries in partitioned database environments.

The updates to the optimizer's cost model for processing in partitioned database environments now better reflect the CPU cost associated with transferring data between database partitions. This improvement will have a positive impact on the performance of data partitioned queries where the CPU costs of data transmission contribute significantly to query execution time.