mongodb索引操作

查看索引

> db.myjihe.getIndexes()
[
        {
                "v" : 2,
                "key" : {
                        "_id" : 1
                },
                "name" : "_id_",
                "ns" : "mydb.myjihe"
        }
]

创建复合索引:"0"字段升序“p”降序

> db.myjihe.createIndex({"0":1,"p":-1})
{
        "createdCollectionAutomatically" : false,
        "numIndexesBefore" : 1,
        "numIndexesAfter" : 2,
        "ok" : 1
}
> db.myjihe.getIndexes()
[
        {
                "v" : 2,
                "key" : {
                        "_id" : 1
                },
                "name" : "_id_",
                "ns" : "mydb.myjihe"
        },
        {
                "v" : 2,
                "key" : {
                        "0" : 1,
                        "p" : -1
                },
                "name" : "0_1_p_-1",
                "ns" : "mydb.myjihe"
        }
]

删除索引

> db.myjihe.dropIndex({"0":1,"p":-1})
{ "nIndexesWas" : 2, "ok" : 1 }
> db.myjihe.getIndexes()
[
        {
                "v" : 2,
                "key" : {
                        "_id" : 1
                },
                "name" : "_id_",
                "ns" : "mydb.myjihe"
        }
]