AskTom On SORT MERGE vs. HASH JOINS

Ever wondered what the difference is between the SORT MERGEs and HASH JOINs found in Explain Plans? Tom Kyte gives us the lowdown...