MONGODB高级操作

1、聚合

 a、count

db.MobileArea.count()

 

b、distinct

db.MobileArea.distinct("Mobile")

 

c、group

db.MobileArea.group({
    "key":{"Mobile":true},
    "initial":{"Mobile":[]},
    "$reduce":function(counts,mob){
        mob.Mobile.push(counts.Mobile);
        },
        "finalize":function(out){
            out.count=out.Mobile.length;
            },
        "condition":{"Province":"山东"}
    })

 

 

2、性能分析函数

db.MobileArea.find().explain()

3、索引

a、创建索引

db.MobileArea.ensureIndex({"Mobile":-1})

db.MobileArea.ensureIndex({"Mobile":-1},{"unique":true})

db.MobileArea.ensureIndex({"Province":-1},{"City":-1})

 

b、查询索引

db.MobileArea.getIndexes()

 

c、删除索引

db.MobileArea.dropIndex("Province_-1")