最近在做mongodb的分析统计，发现group分组有多种做法，和sql还真是不太样，需要写点js代码，直接贴示例代码：

这是我的collection，名字：t_user_@R_404_182@
public class User@R_404_182@ implements Serializable {
…
private Integer userId;
private BigDecimal user@R_404_182@;
…
}

int userCount = 0;

GroupBy groupBy = GroupBy.key("userId")
                .initialDocument("user@R_404_182@Total:0,user@R_404_182@Count:0,user@R_404_182@Avg:0}") 
                .reduceFunction("function(doc,prev){ if(doc.user@R_404_182@ != null){"
                                                         +"prev.user@R_404_182@Total += parseFloat(doc.user@R_404_182@);"
                                                         +"prev.user@R_404_182@Count + =1;"
                                                         +"}"
                                                      +"}")                                                         
               .finalizeFunction("function(prev){ if(prev.user@R_404_182@Count > 0) {"
                                                       +"prev.user@R_404_182@Avg=prev.user@R_404_182@Total / prev.user@R_404_182@Count;"
                                                       +"}"
                                                 +"}");

GroupByResults<User@R_404_182@> r = evaluationTemplate.group("t_user_@R_404_182@",groupBy,User@R_404_182@.class);
BasicDBList list = (BasicDBList)r.getRawResults().get("retval"); 

for (int i = 0; i < list.size(); i ++) { 
    BasicDBObject obj = (BasicDBObject)list.get(i); 
    int userId = Double.valueOf(String.valueOf(obj.get("userId"))).intValue();

    logger.info(String.format("userId=%s json=%s ",userId,Utils.toJSONString(obj)));
}

登录控制台，建唯一索引(后台创建唯一的复合索引)：
db.t_user_@R_404_182@.ensureIndex({“userId”:1},{background:1,unique:1});

–查看索引
db.t_user_@R_404_182@.getIndexes()

–查看索引大小
db.t_user_@R_404_182@.totalIndexSize();
–重建索引
db.t_user_@R_404_182@.reIndex()
–删除索引
–db.t_user_@R_404_182@.dropIndex(“id_1”)

–使用索引的结果
db.t_user_@R_404_182@.find({“userId”:1000}).explain();

更多查询优化：AnalyzeQuery Performance ：http://docs.mongodb.org/manual/tutorial/analyze-query-plan/