MongoDB 系列 - 索引操作(5)
2021-10-14 本文已影响0人
嗚嗚雲
- 添加索引
db.report_case.createIndex({reportId:1});
db.report_case.createIndex({reportId:1,yn:1});
db.report_case.createIndex({reportId:1,"reportDetail.sceneList.sceneId":1});
db.report_case.createIndex({reportId:1,"reportDetail.sceneList.sceneId":1,"reportDetail.sceneList.caseList.caseId":1});
db.report_case.createIndex({sceneSuiteId:1});
db.report_case.createIndex({sceneSuiteId:1,yn:1,createTime:-1});
db.report_case.createIndex({status:1,executiveMachine:1,yn:1,createTime:1});
db.report_case.createIndex({createTime:-1,"reportDetail.sceneList.sceneId":1});
- 查询索引
db.report_case.getIndexes()
- 删除索引
db.report_case.dropIndex('index_name')