Home -> Usenet -> comp.databases.theory -> Re: union all vs. left outer join

Re: union all vs. left outer join

From: vc <boston103_at_hotmail.com>
Date: 7 Nov 2005 13:46:19 -0800
Message-ID: <1131399979.135310.249300_at_g44g2000cwa.googlegroups.com> 







henrik.sorensen_at_balcab.ch wrote:


> Warning long mail ...


>

> For several days I have tried to figure out why two sql with an union all

> is much faster than using a single sql with left outer join.





What do you mean much faster ?  In Oracle,  both queries execute in
approximately the same time ~15-16 msec.




> Henrik

Received on Mon Nov 07 2005 - 22:46:19 CET












Original text of this message