Sql优化题目

[wxm19810423]

SELECT COUNT(temp.status),temp.is_backup FROM (SELECT * FROM `RESOURCE_BASE` WHERE STATUS!=1) temp GROUP BY temp.is_backup

这样写感觉性能很差，看看各位有没有好的写法。

[叶半欲缺]

引用 6 楼 ghostkngiht 的回复:

SELECT COUNT(1), is_backup FROM resource_base WHERE status <> 1 GROUP BY is_backup

顶一个

[tony4geek]

你在表的方面优化。

[Java狂魔]

[code =sql]SELECT COUNT(temp.status),temp.is_backup FROM `RESOURCE_BASE` WHERE STATUS!=1 GROUP BY is_backup [/code] 这样写不行么

[Java狂魔]

SELECT COUNT(temp.status),temp.is_backup FROM `RESOURCE_BASE` temp WHERE STATUS!=1 GROUP BY is_backup

[「已注销」]

select count(STATUS) ,IS_BACKUP from RESOURCE_BASE where STATUS != 1 group by TEMP.IS_BACKUP

[ghostkngiht]

SELECT COUNT(1), is_backup FROM resource_base WHERE status <> 1 GROUP BY is_backup