gpt4o.so
分蛋以父之名302
获得徽章 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")展开313
![[吐舌]](http://lf-web-assets.juejin.cn/obj/juejin-web/xitu_juejin_web/img/jj_emoji_95.6b0752f.png)
![[谢谢]](http://lf-web-assets.juejin.cn/obj/juejin-web/xitu_juejin_web/img/jj_emoji_112.2dd347d.png)