In my contrived tests, with a fast hash function that produced ~.002% collisions, the HashMap performed ~30% slower than using a plain old object with a toString() function that generated unique ...

The SQL LEFT JOIN returns all rows from the left table, even if there are no matches in the right table. This means that if the ON clause matches 0 (zero) records in the right table; the join will ...