MySQL 8.0.18 hash join does not support left / right join connection

In MySQL 8.0.18, a new function of hash join has been added, which is applicable to the fields that have not been indexed to do equivalent Association query. In previous versions, if the joined fields were not indexed, the query speed would be very slow, and the optimizer would use BNL (block nesting) algorithm. Hash […]