来来来，给这个 sql 来个优化方案

25次阅读

共计 500 个字符，预计需要花费 2 分钟才能阅读完成。

SELECT
kdojhad,
k3jyqb4,
(
(
(
SELECT MAX
(calc_65b868adfd5b141878679de2)
FROM
(
SELECT
(SUM ( t623be1f4fd5b1419766ff0b8.”c2″) ) AS calc_65b868adfd5b141878679de2,
t623be1f4fd5b1419766ff0b8.”c10″ AS dimension0
FROM
t623be1f4fd5b1419766ff0b8
WHERE
(( t623be1f4fd5b1419766ff0b8.”c11″ = k3jyqb4) AND (t623be1f4fd5b1419766ff0b8.”c10″ = kdojhad) )
GROUP BY
dimension0
) AS res
)
)
) AS kxxz3vy
FROM
(SELECT t623be1f4fd5b1419766ff0b8.”c11″ AS k3jyqb4, t623be1f4fd5b1419766ff0b8.”c10″ AS kdojhad FROM t623be1f4fd5b1419766ff0b8 GROUP BY kdojhad, k3jyqb4) AS dataSource