Join us for an insightful discussion on 27 May, 2025 at 11:00 AM ET. Optimal query access plans are essential for good data server performance and it is the Db2 query optimizer's job to choose the best access plan. The optimizer is a very sophisticated component of the data server, tasked with the challenging job of choosing good access plans for the variety of features and table organizations supported by Db2. The optimizer can automatically rewrite complex SQL resulting in huge performance improvements. It models various aspects of Db2 runtime so that it can choose the best access plan out of hundreds of thousands of possible options. Attend this session to get an overview of how the optimizer works and to get some tips on how to understand its decisions and control its behaviour.

Click here to register and add the event to your calendar.

Where is the link to join? Check your email the day before the event!

 How to get the most out of this webinar:

• Explore the Db2 Community.

• Ask questions for the presenter by replying to this discussion post before, during and after the webinar. John Hornibrook will be happy to answer your questions and share insights.

• Check out upcoming Db2 events here.

We look forward to seeing you there!

Hello Everyone! 

If you missed the Webinar on May 27- Back to Basics: Query Optimizer 101

you can find the recording Here .