Sachin Arora's Blog: Nested loops, Hash join and Sort Merge joins – difference?

Anonymous said... With Oracle 10g its perfectly working as you mentioned like after increasing rownum ,plan changed from "Nested loop" to "Hash join" . But for Oracle 11g plan remains same, means its uses ""Nested loop" even after changing artificial stat

oracle-online-help.blogspot.co