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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Optimization: change in access path to one table changes join strategy to another table...

RE: Optimization: change in access path to one table changes join strategy to another table...

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Thu, 24 Aug 2006 17:10:22 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF6154DF@MSXVS04.trivadis.com> 





John



> 1) My guess is that predicate pushing of join predicates isn't

> working. 




I just realized that join predicates pushing isn't working simply
because the view is (outer) joined with a hash join. Only with a (outer)
nested loop it is possible to achieve a push of the join predicates.




HTH



Chris

--
http://www.freelists.org/webpage/oracle-l


Received on Thu Aug 24 2006 - 10:10:22 CDT












Original text of this message













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