iggyfernandez.wordpress.com
SQL 101: Deep Left Trees, Deep Right Trees, and Bushy Trees! Oh, My!
An Oracle EXPLAIN PLAN can be a “deep left tree,” a “deep right tree,” or a “bushy tree.” Deep left trees are probably the most common because of an inherent bias of the Oracle optimizer. Consider …