Why explain plan not same?

[automona]

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

[chendan]

nothing pop up in my head immediately. But do you assign same amount of memory in vm as you had in server1? Did you try run stat after clone to vm?