哈哥勾编程
获得徽章 0
赞了这篇文章
赞了这篇文章
赞了这篇文章
赞了这篇文章
赞了这篇文章
赞了这篇文章
赞了这篇沸点
sql求助，数据库有分区，执行下面sql，为什么不走索引，但是去掉max这个聚合函数就能走索引
EXPLAIN
SELECT
DATE_FORMAT(t.date, "%Y-%m") AS time,
max(t.power) AS power
FROM simulation_infer.extreme_weather_sjzt_trade_load t
WHERE 1=1
and t.org_code = 99
AND t.trade_code =0
and t.date >= "2024-01-01"
AND t.date <= "2025-05-01"
GROUP BY DATE_FORMAT(t.date, "%Y-%m")
EXPLAIN
SELECT
DATE_FORMAT(t.date, "%Y-%m") AS time,
max(t.power) AS power
FROM simulation_infer.extreme_weather_sjzt_trade_load t
WHERE 1=1
and t.org_code = 99
AND t.trade_code =0
and t.date >= "2024-01-01"
AND t.date <= "2025-05-01"
GROUP BY DATE_FORMAT(t.date, "%Y-%m")
展开
3
13
赞了这篇文章
赞了这篇文章
赞了这篇文章
赞了这篇文章
![[可怜]](http://lf-web-assets.juejin.cn/obj/juejin-web/xitu_juejin_web/img/jj_emoji_5.ece2a96.png)
赞了这篇文章