想要優化一句關于group by語句，不知道要從何下手，求思路
SELECT
adv_id,
network_id,
SUM(re_click) AS clk,
SUM(deny_click) AS dny_clk,
SUM(re_conver) AS re_ins,
SUM(mat_conver) AS mat_ins,
SUM(def_conver) AS def,
SUM(cost) AS cost,
SUM(earn) AS earn
FROM ams_data_hourly_2018_03 WHERE start_time BETWEEN 1519862400 AND 1519948799 GROUP BY
adv_id,
network_id
explain：
索引：
求大神指點
- 4 回答
- 0 關注
- 908 瀏覽
添加回答
舉報
0/150
提交
取消