Re: very slow outer join

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: Fri, 4 May 2001 08:04:37 +0100
Message-ID: <988959829.315740@dionysos>

Take a look at my web-page:

http://home.clara.net/dwotton/dba/ojoin2.htm

It explains exactly what is happening and why.

Dave.

--
If you reply to this newsgroup posting by email, remove the "nospam"
from my email address first.

gene01_at_smalltime.com wrote in message ...


>I am doing an SQL query which uses an outer join.  The

>query takes forever to run (forever = more than I'm willing

>to wait).  If I change the outer join to a regular join,

>it takes just over four seconds.  I'm looking for some

>advice on how I can improve this situation.  (This is

>on Oracle 8i (8.1.5.0.0).

>

Received on Fri May 04 2001 - 02:04:37 CDT