转帖,来源:http://www.cnblogs.com/zox2011/archive/2012/09/12/2681797.html 结论: 不管是加不加索引 group by 都比 distinct 快