Webinar: Optimizing Hash Join for columnar tables

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

The hash join algorithm 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. The session will cover an overview of Hash Join, drawbacks of existing implementation, the proposed solution, and performance metrics comparing the feature-enabled and disabled scenarios.

Speakers:

Ajith Krishnan R

Ajith Krishnan R is a software developer on the Db2 Runtime team. He has 3 years of experience working with Db2 and has an overall experience of 9 years. He joined the db2 development team in Kochi, India 3 years back.

Ian Finlay

#db2webinarseries

#globaldata-event