We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Hash join in MySQL 8.0

8
 Cite
 Share
 Related Material
 Download
 Purchase
Logo of FOSDEM VZWFOSDEM VZW
 Grøvlen, Øystein

Formal Metadata

Title
Hash join in MySQL 8.0
Title of Series
Number of Parts
287
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
Hash join was introduced in MySQL 8.0.18 and was presented for the first time at FOSDEM 2020. Since then, the performance of hash join has been improved, and I will present results that show this. We will also discuss what kind of queries benefit from hash join, what you need to do for hash join to be used, and how to tune your system for optimal hash join performance.