Re: Outer Join reads all rows from underlying tables

No, I am the only person with any Oracle knowledge on site.

I gather stats on the tables nightly so the optimizer should have up-to-date info to use as part of the parse phase.

Which init.ora parameters would cause this behavior..? The plan itself is a sensible approach (considering the expected row counts) but it seems that the WHERE clause is not being applied to the view definition.

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:01:30 CDT