Re: Why hash join doesn't happens in 10g, but yes in 9i
- From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 31 Mar 2006 14:49:45 -0400
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
Other related posts:
- » Re: Why hash join doesn't happens in 10g, but yes in 9i