Question: what is the difference between nested loop and hash join in oracle?
Answer: Hash joins - In a hash join, the Oracle database does a full-scan of the driving table, builds a RAM hash table, and then probes for matching rows in the other table. ... In a nested loops join, we have two tables a driving table and a secondary table.