目前,使用Union需要4-6秒,所有这些都需要大约4秒&对于Union,获取数据大约需要6秒。2,5,13,14, 15, 16, 17, 18, 19, 23,8,25,39) smsFDGOrder.StatusID IN(8,12,23,25) UNIONsmsFDGPatientOrder.StatusID IN(select id FROM smsStatus WHERE ID<>3) AND smsFDGOrder.StatusID IN (8,12)
select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 unionselect 1 union select 2 union select 3 union select 4 union select 5 union select 6
SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) t1,
(S