SQL(列转行)优化

[nuoboxgx]

表大概100万数据

由以下的SQL Union而成
实际执行时耗时5分钟以上
及其烦恼
高人帮着优化一下啊?

是不是可以把公共字段提出来不用每次都Union啊 (公共字段F29,F1,F2,F7,F31,F3,F4,F8)

SELECT  F29,F1,F2,F7,F31,F3,F4,F8,F9 AS UF9,F19 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL) 
UNION ALL 
SELECT F29,F1,F2,F7,F31,F3,F4,F8,F10 AS UF9,F20 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL) 
UNION ALL 
SELECT F29,F1,F2,F7,F31,F3,F4,F8,F11 AS UF9,F21 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL) 
UNION ALL	
SELECT F29,F1,F2,F7,F31,F3,F4,F8,F12 AS UF9,F22 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL) 
UNION ALL	
SELECT F29,F1,F2,F7,F31,F3,F4,F8,F13 AS UF9,F23 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL) 
UNION ALL 
SELECT F29,F1,F2,F7,F31,F3,F4,F8,F14 AS UF9,F24 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL) 
UNION ALL 
SELECT F29,F1,F2,F7,F31,F3,F4,F8,F15 AS UF9,F25 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL) 
UNION ALL 
SELECT F29,F1,F2,F7,F31,F3,F4,F8,F16 AS UF9,F26 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL) 
UNION ALL 
SELECT F29,F1,F2,F7,F31,F3,F4,F8,F17 AS UF9,F27 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL) 
UNION ALL 
SELECT F29,F1,F2,F7,F31,F3,F4,F8,F18 AS UF9,F28 AS UF19 FROM DMSRC.clhsg2 WHERE (F31='02' OR F31 IS NULL)

[nuoboxgx]

self 顶一下

[WWWWA]

是不是可以把公共字段提出来不用每次都Union啊：可以用视图 OR 临时表，
贴记录及要求结果出来看看

[yangxiao_jiang]

用UNION ，在最外面用一下distinct一下。