Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2011
    Posts
    10

    Unanswered: Why explain plan not same?

    Hi All

    I clone db2 database from server1 to my vmware
    and try to ran explain plan same query, same #rows, same index and primaky but not same explain plan
    server1 use indexes but my vmware is table scan

    what happen?


    Thanks

  2. #2
    Join Date
    Nov 2011
    Posts
    334
    Could you plz put the two different explains here?
    The db2exfmt output is prefered.

  3. #3
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    Server configuration (CPU, memory, hard disk speed) and other parameters (bufferpool size) impact access plan. See the attached link for details.

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

    Satya..

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You are running on different hardware, possibly with a different number of (virtual) CPUs, more/less memory, ... So you'll usually expect the plans to be different as soon as the statements become reasonably more complex.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •