Hi guys,
i got the following query:
SELECT 0xFCDE62BD682D6247A2B0D2E1DFFF1EAD, ConfGRAssoc.ConfID, ConfGRAssoc.BlockDate, ConfGRAssoc.ConfGRAssocID, ConfGRAssoc.AllotmentIDPhysical, ConfGRAssoc.BlockedRooms, ConfGRAssoc.RoomRate
FROM ( ( (RoomType INNER JOIN ConfGRAssoc ON RoomType.RoomTypeID = ConfGRAssoc.GuestRoomID)
LEFT JOIN ConfGRAssoc AS AllotGR ON ConfGRAssoc.AllotmentIDPhysical = AllotGR.ConfID AND ConfGRAssoc.BlockDate = AllotGR.BlockDate AND ConfGRAssoc.GuestRoomID = AllotGR.GuestRoomID)
INNER JOIN Conference ON ConfGRAssoc.ConfID = Conference.ConfID)
WHERE ConfGRAssoc.OccupancyID In (0x1882AA555328D2118C080040F6240F03,0x1282AA555328 D2118C080040F6240F03,0xA37EA2045F93D211941800104B9 E7ED2,0xA67EA2045F93D211941800104B9E7ED2)
AND ((AllotGR.ConfID) Is Null)
AND (ConfGRAssoc.BlockDate BETWEEN { ts '2007-04-01 00:00:00'} AND { ts '2008-03-31 00:00:00'})
AND ConfGRAssoc.AllotmentIDPhysical IN (0x28C6B8F90A26DF4F8C0BFBAD69C330F2, 0x2C9ADBAB31EEEA44B5B11C15AF99F442, 0x4FFE01AC0F5B8342BAF196361FF813B6, 0xCD7ECE9DFE2F5549B0DAC3EDDCF52EA5) AND RoomType.Suite = 0
this query has different performance on development (3sec) & production (12sec) server.
i found that the execution plan on the 2 servers are different. Dev uses parallelism but prod doesn't. Later i found that there are 4 CPUs on dev but only 2 CPUs on prod.
Is there any way i can force prod to use parallelism also?
thanks,
mandy