场景:有一个关于分类记录collection,分类name(string,中文,英文,数字等组成)字段上有索引方便快速筛选某个分类记录,现在查询出来需要排序,查询条件{name:"F1"},排序条件{_id:-1}
mongodb查询explain分析,这是winningPlan
{"stage": "SORT",
"planNodeId": 3,
"sortPattern": { "_id": 1 },
"memLimit": 104857600,
"limitAmount": 5,
"type": "simple",
"inputStage": {
"stage": "FETCH",
"planNodeId": 2,
"inputStage": {
"stage": "IXSCAN",
"planNodeId": 1,
"keyPattern": { "name": -1 },
"indexName": "name_-1",
"isMultiKey": false,
"multiKeyPaths": { "name": [] },
"isUnique": false,
"isSparse": false,
"isPartial": false,
"indexVersion": 2,
"direction": "forward",
"indexBounds": {
"name": ["[\"F1\", \"F1\"]"]
}
}
}
SORT + FETCH + IXSCAN 这算不算bad查询,通常是FETCH + IXSCAN。