My Favourite Db2 Query Optimization Registry Variables

Download PDF

Watch recording (logged in Tridex members only)

Session title: My Favourite Db2 Query Optimization Registry Variables

Session abstract: Optimal query access plans are essential for good data server performance, and it is the query optimizer’s job to choose the best one.

For most systems, only minimal tuning is necessary if automatic statistics collection is enabled. However, there are more complex scenarios and configurations where the query optimizer needs some help to get the best access plan and there are Db2 registry variables available to handle these. Query optimization registry variables are dynamic so they can be applied without restarting the database and they can also be specified using optimization guidelines. Attend this session to learn what is available and how they can help improve query performance for your database.

Speaker biography: John is a Senior Technical Staff Member responsible for relational database query optimization on IBM’s distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator (IDAA) and Db2 Big SQL. John also works closely with customers to help them fully realize the benefits of IBM’s relational DB technology products.