The best thing you could do is avoid rules of thumb like this.
Start by read the Oracle documentation and understanding the fundamental differences between each join type -- there is no one that is universally better than others.
Oh, here's the only rule of thumb -- analyze your tables, indexes, and skewed columns.




Reply With Quote