Hash join in Oracle

Hash join in Oracle with example

February 12, 2016 by techgoeasy 3 Comments

What is hash Join in Oracle? Hash joins are used when the joining large tables or when the joins requires most of the joined tables rows. This is used for equality joins only Algorithm for Oracle Hash Join 1) The optimizer uses smaller of the 2 tables to build a hash table in memory.Small table […]