Should Sybase v10.0.1.3960 running on VMware still be able to use parallel table scans ?
I have some fairly simple SQL that performs a couple of joins from a small customer table to a reasonable head table then onto quite a large lines table. Some of the where clause is using fields that aren't in the index, but on my development machine it takes a few seconds to run, on our live servers it takes even less time to run, however on our test system (which uses Vmware) it runs for at least 15mins before I get bored and kill it.
I've checked the plans on all the machines and the test server doesn't try to use parallel table scans but the others do. I've not had much experience of VMware or parallel table scans (I didn't even know about them until I checked the plan), Is there anything obvious I should be looking into ?
Several possibilities jump to mind; seeing the graphical plan would help.
Some things to consider:
answered 12 Oct '10, 17:11