Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> 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@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 - 15:46:19 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US