Hash Join require Full Table Scan
- by Pedro Magalhaes
So, I want to know if to make a Hash Join between two tables is necessary to make a full table scan on the collumns?
If i want to join COL1 wiht COL2, and COL1 is smaller, the It makes a full scan in COL1 creating a Hashmap then makes a full scan in COL2 using the sabe hash function.
Is this correct?