Force Parallelism

[MTYWONG]

Hi guys,

i got the following query:

SELECT 0xFCDE62BD682D6 247A2B0D2E1DFFF 1EAD, ConfGRAssoc.Con fID, ConfGRAssoc.Blo ckDate, ConfGRAssoc.Con fGRAssocID, ConfGRAssoc.All otmentIDPhysica l, ConfGRAssoc.Blo ckedRooms, ConfGRAssoc.Roo mRate
FROM ( ( (RoomType INNER JOIN ConfGRAssoc ON RoomType.RoomTy peID = ConfGRAssoc.Gue stRoomID)
LEFT JOIN ConfGRAssoc AS AllotGR ON ConfGRAssoc.All otmentIDPhysica l = AllotGR.ConfID AND ConfGRAssoc.Blo ckDate = AllotGR.BlockDa te AND ConfGRAssoc.Gue stRoomID = AllotGR.GuestRo omID)
INNER JOIN Conference ON ConfGRAssoc.Con fID = Conference.Conf ID)
WHERE ConfGRAssoc.Occ upancyID In (0x1882AA555328 D2118C080040F62 40F03,0x1282AA5 55328D2118C0800 40F6240F03,0xA3 7EA2045F93D2119 41800104B9E7ED2 ,0xA67EA2045F93 D211941800104B9 E7ED2)
AND ((AllotGR.ConfI D) Is Null)
AND (ConfGRAssoc.Bl ockDate BETWEEN { ts '2007-04-01 00:00:00'} AND { ts '2008-03-31 00:00:00'})
AND ConfGRAssoc.All otmentIDPhysica l IN (0x28C6B8F90A26 DF4F8C0BFBAD69C 330F2, 0x2C9ADBAB31EEE A44B5B11C15AF99 F442, 0x4FFE01AC0F5B8 342BAF196361FF8 13B6, 0xCD7ECE9DFE2F5 549B0DAC3EDDCF5 2EA5) 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