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: Execution plan differ from oracle 8.1.7 to 9.2

Re: Execution plan differ from oracle 8.1.7 to 9.2

From: Chris <christianboivin1_at_hotmail.com>
Date: 10 Nov 2003 19:59:54 -0800
Message-ID: <da20daf0.0311101959.3520c235@posting.google.com> 





I'd change the parameter hash_join_enabled to false
and it remove the HASH JOIN but the FILTER stay ...
and the execution is very slow ...



I'll recompute the stats tonight with dbms_stats
and check what happen !



Thanks
Received on Mon Nov 10 2003 - 21:59:54 CST












Original text of this message













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