Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem - help appreciated.

Re: Performance problem - help appreciated.

From: srivenu <srivenu_at_hotmail.com>
Date: 30 Mar 2004 21:38:26 -0800
Message-ID: <1a68177.0403302138.3bb07723@posting.google.com> 





Hi,


In your case, the outer join is restricting the join order.
Remove the outer join and test.


It would have been helpful if you have included the plans with each SQL.
regards


Srivenu
Received on Tue Mar 30 2004 - 23:38:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US