Performance enhancements

Db2 11.5.1 contains SQL performance enhancements that continue to make the Db2 data server an industrial-strength data server solution that is suitable for any size of organization.

Note: The enhancements in this topic are included in the Db2 11.5.1 mod pack release, which is available for the following Db2 products:

The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS)
The container micro-service deployment of Db2 on Red Hat OpenShift
The Db2 cartridge used by IBM Cloud Pak for Data

The following table displays a list of performance enhancements in Db2 11.5.1:

Table 1. Performance enhancements in Db2 11.5.1
Enhancement	Description
Enhanced query performance against column organized tables	Query performance against column organized tables is enhanced by improvements to memory utilization. This feature is most utilized by complex queries on column organized tables, and in particular, by queries involving wide value types that have a large percentage of the column values shorter than the defined schema width.