Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXPLAIN PLAN differences
Seems as if execution plans are different.
Use stored outlines to provide execution plan stability.
Read about this new feature of Oracle8i.
"traceable1" <traceable1_at_hotmail.com> wrote in message
news:8551d8c9.0206040837.364b51f7_at_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:50:50 CDT