[thelist] Truth about Outer Joins vs. Union All in Oracle?

Matt Warden mwarden at gmail.com
Fri Nov 16 10:07:24 CST 2007

On 11/16/07, Matt Warden <mwarden at gmail.com> wrote:
> The following are two versions of the same query, one with a left
> outer join and the other using a union all. After each query is the
> execution plan chosen by the cost-based optimizer.

Yikes, that wrapped badly. I've uploaded a txt file to my server to
save you guys the pain of reformatting:


Matt Warden
Cincinnati, OH, USA

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list