PHP速度優化計畫
SELECT INTO
<SQL> SELECT * INTO TEST123 FROM(SELECT TA001,RTRIM(TA002) AS TA002,TA001+TA002 AS UDF01,TA003,TA006,TA034,TA035,TA015,TA017,TA017-TA015 AS TA, TA013,TA011,TA009,TA010,TA012,TA014,TC075,TD001,TD002,TD003,TC006,MOCTA.UDF03,TA006 AS MC001 FROM MOCTA LEFT JOIN v_COPTCD ON TD001=(SELECT CASE WHEN TA033<> THEN '400' ELSE TA026 END) AND TD002=(SELECT CASE WHEN TA033<> THEN REPLACE(TA033,'*',) ELSE TA027 END) AND TD003=(SELECT CASE WHEN TA033<> AND TA028= THEN TD003 ELSE TA028 END) WHERE TA002>'151101000')X </SQL>