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

Could you plz put the two different explains here?
The db2exfmt output is prefered.

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..

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.