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: Why hash join doesn't happens in 10g, but yes in 9i

Re: Why hash join doesn't happens in 10g, but yes in 9i

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Fri, 31 Mar 2006 14:49:45 -0400
Message-ID: <cd4305c10603311049q4f2f2499k5ae0e19ce0789a5b@mail.gmail.com> 





If found this parameter


alter session set "_optimizer_cost_based_transformation" = OFF;
on 313746.1 metalink note.


But this reduced to 1.72s not to the original time.
I'm asking if someone has another idea, I hope Jhonatan is somewhere
out there :)

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


Received on Fri Mar 31 2006 - 12:49:45 CST












Original text of this message













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