Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Back to Basics: Query Optimizer 101 Webinar

    Posted Wed May 07, 2025 01:43 PM

    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!



      ------------------------------
      IBM TechXchange Community Team
      ------------------------------


    • 2.  RE: Back to Basics: Query Optimizer 101 Webinar

      Posted 20 days ago


      Hello Everyone! 

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

      you can find the recording Here .



      ------------------------------
      Luis Dorantes | Data Community Manager
      IBM
      ------------------------------