Performance enhancements
Db2 version 11.1 contains numerous 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.
The following table displays a list of performance enhancements in 11.1:
Enhancement | Description |
---|---|
Support for NOT LOGGED INITIALLY clause in column-organized tables. | The NOT LOGGED INITIALLY clause can now be used in CREATE TABLE and ALTER TABLE statements that involve column-organized tables. Logging is temporarily disabled when The NOT LOGGED INITIALLY is specified. With logging disabled, operations such as INSERT, UPDATE, or DELETE run faster. |
Reduced number of timeouts and increased throughput on workloads that have a high number of inserts running concurrently with other transactions. | Lock serialization has been improved for Automatic Dictionary Creation during Insert/Ingest/Import which will reduce the number of timeouts and allow more concurrent transactions to complete. |
Improved performance and scalability for high concurrency workloads. | Highly concurrent workloads that have frequently-accessed common pages, such as small table lookups or frequent index access (especially via nested-loop joins) may see improved performance (lower transaction latency, lower latch and lock waits) and scalability (higher degree of concurrency) as result of these changes. |