Re: union all vs. left outer join

From: vc <>
Date: 7 Nov 2005 13:46:19 -0800
Message-ID: <> 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