no wonder some people like nosql so much

@JamesL MySQL supports hash joins

dbfiddle needs mariadb 10.2.7

@JackDouglas ^

But they're up to 10.2.11

@EvanCarroll does it? is it just in the mariadb fork?

some people say the block nested loop optimization creates hash tables. one hash table per buffer of rows from the outer table, and one read of the inner table per buffer.

@JamesL no the code is in MySQL too