-
execution plan not the same in 2 boxes (same RBDMS and DB)
The execution plan could be affected by the box load/ or by the machine characteristics (nb CPUs...). ?
(As I noticed that sometime, we don't have the same execution plan
in our test and production environments : same RDBMS version and same volume for the database).
Anyone have more info about this behaviour ...
Thanks a lot ...
-
has one got up to date stats and the other not? Parallel settings the same?
could be a whole host of things
-
Stat was calculated and both boxes (parallel setting is the same).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|