想要优化一句关于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 关注
- 857 浏览
添加回答
举报
0/150
提交
取消