insert into MY_DW_CALL_CDR_201406 select tabcol_11 ,tabcol_12,tabcol_13,db2list.opp(opp_off) as opp_off,tabcol_15,tabcol_16,tabcol_17,tabcol_18,tabcol_19,tabcol_20,tabcol_21,tabcol_22, tabcol_23,tabcol_...
显示全部insert into MY_DW_CALL_CDR_201406
select tabcol_11 ,tabcol_12,tabcol_13,db2list.opp(opp_off) as
opp_off,tabcol_15,tabcol_16,tabcol_17,tabcol_18,tabcol_19,tabcol_20,tabcol_21,tabcol_22,
tabcol_23,tabcol_24,tabcol_25,tabcol_26,tabcol_27,tabcol_28,tabcol_29,tabcol_30,
tabcol_31 from tablename.call_20140601
union all
select tabcol_11,tabcol_12,tabcol_13,db2list.opp(opp_off) as
opp_off,tabcol_15,tabcol_16,tabcol_17,tabcol_18,tabcol_19,tabcol_20,
tabcol_21,tabcol_22,tabcol_23,tabcol_24,tabcol_25,tabcol_26,tabcol_27,
tabcol_28,tabcol_29,tabcol_30,tabcol_31 from tablename.call_20140602
union all
select tabcol_11,tabcol_12,tabcol_13,db2list.opp(opp_off) as
opp_off,tabcol_15,tabcol_16,tabcol_17,tabcol_18,tabcol_19,tabcol_20,tabcol_21,
tabcol_22,tabcol_23,tabcol_24,tabcol_25,tabcol_26,tabcol_27,tabcol_28,tabcol_29,
tabcol_30,tabcol_31 from tablename.call_20140603
union all
select tabcol_11,tabcol_12,tabcol_13,
db2list.opp(opp_off) as opp_off,tabcol_15,tabcol_16,
tabcol_17,tabcol_18,tabcol_19,tabcol_20,tabcol_21,tabcol_22,tabcol_23,tabcol_24,tabcol_25,
tabcol_26,tabcol_27,tabcol_28,tabcol_29,tabcol_30,tabcol_31 from tablename.call_20140604
union all
select tabcol_11,tabcol_12,tabcol_13,db2list.opp(opp_off) as
opp_off,tabcol_15,tabcol_16,tabcol_17,tabcol_18,tabcol_19,tabcol_20,tabcol_21,
tabcol_22,tabcol_23,tabcol_24,tabcol_25,tabcol_26,tabcol_27,tabcol_28,tabcol_29,
tabcol_30,tabcol_31 from tablename.call_20140605
这个就是要优化的sql
收起