MongoDB 系列 - 索引操作（5）

• 添加索引

    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')