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 -> EXPLAIN PLAN differences

EXPLAIN PLAN differences

From: traceable1 <traceable1_at_hotmail.com>
Date: 4 Jun 2002 09:37:58 -0700
Message-ID: <8551d8c9.0206040837.364b51f7@posting.google.com> 





Please Help!!



If I do an execution plan on the same query on 2 different boxes, I
get different results (Cost 26 vs 158).  What does this mean?  I'm
trying to make the two databases behave the same, but they will not. 
One box has a lot more data than the other, but statistics have been
run. I've checked the OPTIMIZER_MODE, what else could be causing the
difference?


They are both Oracle 8.1.7 on W2K.



Any thoughts are very much appreciated!!



Trace
Received on Tue Jun 04 2002 - 11:37:58 CDT












Original text of this message













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