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