Re: Outer Join reads all rows from underlying tables

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?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)