Re: Outer Join reads all rows from underlying tables

From: Matt <mccmx_at_hotmail.com>
Date: 10 May 2004 01:48:05 -0700
Message-ID: <cfee5bcf.0405100048.1678abd0@posting.google.com>

Statistics gathered with:

dbms_utility.analyze_schema('SCHEMA', 'COMPUTE')

Matt

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1083969445.832473_at_yasure>...
> Matt wrote:
>
> > Hello,
> >
> > I have an outer join which runs very slowly... I've traced the SQL to
> > determine the root cause and I've noticed that the query reads 'every'
> > row from both of the row sets returned from one of the views in the
> > statement.
> >
> > Is this to be expected with the outer-join implementation in 8i...?
>
> No. But to determine why your query is requires a thorough understanding
> of everything from when statistics were last run, how, init parameters,
> indexes, and numerous other factors.
>
> Do you have someone senior that you can ask to help you with this?
Received on Mon May 10 2004 - 03:48:05 CDT