select so.userid,sum(so.price) as price,count(so.orderid) as num from so where so.deleteflag = 0 and so.createdate>='2008-05-01 00:00:00' and so.createdate <'2008-06-01 00:00:00' group by so.userid order by num desc
mysql>explain select so.userid,sum(so.price) as price,count(so.orderid) as num from so where so.deleteflag = 0 and so.createdate>='2008-05-01 00:00:00' and so.createdate <'2008-06-01 00:00:00' group by so.userid order by num desc ; 执行后，看看有没有可以优化的地方。
