The Db2® 11.5.5 release contains performance enhancements that improve queries against column-organized tables.
|Enhanced query performance against column organized tables||
Query performance against column organized tables is further enhanced by key improvements in
||When database activation occurs and deferred memory commit is enabled (see
DB2_DEFER_MEMORY_COMMIT), the initialization of bufferpool and locklist memory
is performed asynchronously in the background, which allows database activation to complete and the
database to be available for application connections sooner. During the short time-period after
database activation while this memory is being initialized in the background, a