DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: execution plan not the same in 2 boxes (same RBDMS and DB)

  1. 10-27-2003, 04:07 AM #1
    nour
    nour is offline Junior Member
    Join Date
    Feb 2003
    Posts
    23

    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 ...
    Reply With Quote Reply With Quote
  2. 10-27-2003, 04:19 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    has one got up to date stats and the other not? Parallel settings the same?

    could be a whole host of things
    Reply With Quote Reply With Quote
  3. 10-27-2003, 06:35 AM #3
    nour
    nour is offline Junior Member
    Join Date
    Feb 2003
    Posts
    23
    Stat was calculated and both boxes (parallel setting is the same).
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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