Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties

Download PDF

Watch recording (logged in Tridex members only)

Session title: Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties

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. However, occasionally no amount of statistics or tuning is enough to get the access plan you want. Or your application is effectively down, due to a poorly performing query, and there isn’t time to implement best practices.

When these situations arise, Db2 optimization profiles and guidelines can be used to correct the access plan and get your application performing well again, quickly. Optimization profiles can specify various aspects of an access plan, can control automatic query rewriting or can control the optimizer’s plan search space. Guidelines can be specified with or without modifying your application. This presentation will show you what options are available and how to use them effectively.

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.