SELECT SUM(DECODE(ID1,123,VALUE * COUNT)) INTO DATA
FROM DATA_VIEW GROUP BY ID2,ID3;
commit;
SELECT SUM(DECODE(ID1,123,VALUE * COUNT)) INTO DATA
FROM DATA_VIEW GROUP BY ID2,ID3;试一下看看
FROM DATA_VIEW GROUP BY ID2,ID3;
commit;
SELECT SUM(DECODE(ID1,123,VALUE * COUNT)) INTO DATA
FROM DATA_VIEW GROUP BY ID2,ID3;试一下看看
analyze一下DATA_VIEW先
analyze table DATA_VIEW compute statistics;
后差别就是0.02秒和0.04秒了,
谢谢nebulaly(nebulaly)