A JOIN execution method that builds a hash table from the join key and uses it to quickly find matching rows.
Unlike a nested loop join, a hash join builds a hash table from one of the tables in advance, greatly reducing the number of comparisons needed. It's often the method chosen when joining two large tables where an index can't be used.
© 2026 ITBGM