Db2

 View Only

Optimizing Hash Join for columnar tables Webinar

  • 1.  Optimizing Hash Join for columnar tables Webinar

    Posted Mon September 16, 2024 11:08 AM
    Edited by Kat Jarvis Tue October 01, 2024 03:01 PM

    If you missed the webinar, you can find the recording here

    Join us for an insightful discussion on 1 October, 2024 at 11:00 AM ET to get an overview of the hash join algorithm which is a fundamental technique in database systems, widely used for executing join operations efficiently, especially when dealing with large datasets. The existing hash join implementation of CDE has some drawbacks while processing queries involving large number of payload columns and wide payload columns (fixed-length, variable-length or mixed). The session delves into the improvements implemented in the db2 columnar engine's hash join execution, with the primary objectives of reducing memory usage and improving overall performance. Ajith Krishnan R and Ian Finlay will also cover an overview of Hash Join, drawbacks of existing implementation, the proposed solution, and performance metrics comparing the feature-enabled and disabled scenarios.

    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. Ajith Krishnan R and Ian Finlay will be happy to answer your questions and share insights.

    • Check out upcoming Db2 events here.

    We look forward to seeing you there!



    ------------------------------
    Kat Jarvis
    ------------------------------