SELECT vcd.floor, vcd.`storage`, AVG( vcd.coreTemperature ) AS coreTemperature, AVG( vcd.coreWater ) AS coreWater, AVG( vcd.power ) AS power, AVG( vcd.rssi ) AS rssi, AVG( vcd.snr ) AS snr FROM v_core_data vcd WHERE vcd.floor IS NOT NULL AND vcd.createTime >= '2023-06-12 00:00:00' AND vcd.createTime <'2023-06-12 23:59:59' GROUP BY vcd.floor, vcd.STORAGE 这个sql的运行时间太长，帮我修改一下

可以尝试以下优化方法：

1. 添加合适的索引：对于 `vcd.createTime`、`vcd.floor`、`vcd.storage` 这些经常用于查询和筛选的字段，可以添加索引来优化查询速度。

2. 减少查询的数据量：可以通过限制查询时间范围，或者只查询需要的字段来减少查询的数据量。

3. 优化 GROUP BY 子句：可以考虑将 `GROUP BY vcd.storage` 移除，或者将 `GROUP BY vcd.floor` 和 `GROUP BY vcd.storage` 的顺序颠倒，看看哪种方式更快。

修改后的 SQL 如下：

SELECT
vcd.floor,
vcd.storage,
AVG(vcd.coreTemperature) AS coreTemperature,
AVG(vcd.coreWater) AS coreWater,
AVG(vcd.power) AS power,
AVG(vcd.rssi) AS rssi,
AVG(vcd.snr) AS snr
FROM
v_core_data vcd
WHERE
vcd.floor IS NOT NULL
AND vcd.createTime >= '2023-06-12 00:00:00'
AND vcd.createTime < '2023-06-13 00:00:00'
GROUP BY
vcd.storage,
vcd.floor