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

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

瀏覽:1192
日期:2024-08-30
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...看更多