分蛋以父之名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")
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
赞了这篇文章
赞了这篇沸点
赞了这篇文章
赞了这篇文章
赞了这篇文章