mysql查询优化，谁能帮我优化查询啊？我这个太慢了，慢死了

SELECT mobileuserid,caozuoleixing,caozuozhi,xiguanzhi FROM 表A WHERE xiguanzhi>2
GROUP BY mobileuserid,caozuoleixing,caozuozhi,xiguanzhi
ORDER BY mobileuserid,caozuoleixing,xiguanzhi DESC LIMIT 3000

SELECT distinct mobileuserid,caozuoleixing,caozuozhi,xiguanzhi FROM 表A WHERE xiguanzhi>2
ORDER BY mobileuserid,caozuoleixing,xiguanzhi DESC LIMIT 3000

看资料型态与笔数
可以对xiguanzhi建index

没有必要group by还有建索引，楼上说的很正确

没有必要group by还有建索引，楼上说的很正确