DB2 11.1. – A Query Optimizer Perspective

DB2 11.1 and 11.1.1.1 provide a number of new features to extend DB2 capability and provide improved performance. Leading the list is BLU Acceleration in a massively parallel processing (MPP) configuration, which allows DB2's leading edge compressed column-organized table support to run across multiple servers to provide the ability to support databases that are hundreds of terabytes in size. Additionally, a number of improvements have been made to BLU join, sort, correlated subquery and analytic function processing to provide even better performance in all BLU configurations. This presentation will help you understand how BLU technology works, what has changed in DB2 11.1/11.1.1.1 and the role of the query optimizer in achieving industry-leading performance.