Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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)Received on Fri May 07 2004 - 17:37:25 CDT
![]() |
![]() |