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: http://mattwarden.com/explainplan.txt -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.