Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies如果我的查詢包含 $or 運算子，是否可以在 MongoDB 索引中進行查詢？
是的，你可以這樣做。首先，你需要建立一個索引，然後使用 explain()。我們先建立一個 MongoDB 索引。這是查詢
> db.indexOrQueryDemo.ensureIndex({"First":1});將生成以下輸出
{
"createdCollectionAutomatically" : false,
"numIndexesBefore" : 2,
"numIndexesAfter" : 3,
"ok" : 1
}建立第二個索引的查詢如下
> db.indexOrQueryDemo.ensureIndex({"Second":1});將生成以下輸出
{
"createdCollectionAutomatically" : false,
"numIndexesBefore" : 3,
"numIndexesAfter" : 4,
"ok" : 1
}以下是帶有索引的 $or 運算子的查詢。我們在此也使用了 explain()
> db.indexOrQueryDemo.find({$or:[{First:1}, {Second:2}]}).explain();將生成以下輸出
{
"queryPlanner" : {
"plannerVersion" : 1,
"namespace" : "test.indexOrQueryDemo",
"indexFilterSet" : false,
"parsedQuery" : {
"$or" : [
{
"First" : {
"$eq" : 1
}
},
{
"Second" : {
"$eq" : 2
}
}
]
},
"winningPlan" : {
"stage" : "SUBPLAN",
"inputStage" : {
"stage" : "FETCH",
"inputStage" : {
"stage" : "OR",
"inputStages" : [
{
"stage" : "IXSCAN",
"keyPattern" : {
"First" : 1
},
"indexName" : "First_1",
"isMultiKey" : false,
"multiKeyPaths" : {
"First" : [ ]
},
"isUnique" : false,
"isSparse" : false,
"isPartial" : false,
"indexVersion" : 2,
"direction" : "forward",
"indexBounds" : {
"First" : [
"[1.0, 1.0]"
]
}
},
{
"stage" : "IXSCAN",
"keyPattern" : {
"Second" : 1
},
"indexName" : "Second_1",
"isMultiKey" : false,
"multiKeyPaths" : {
"Second" : [ ]
},
"isUnique" : false,
"isSparse" : false,
"isPartial" : false,
"indexVersion" : 2,
"direction" : "forward",
"indexBounds" : {
"Second" : [
"[2.0, 2.0]"
]
}
}
]
}
}
},
"rejectedPlans" : [ ]
},
"serverInfo" : {
"host" : "DESKTOP-QN2RB3H",
"port" : 27017,
"version" : "4.0.5",
"gitVersion" : "3739429dd92b92d1b0ab120911a23d50bf03c412"
},
"ok" : 1
}
更新於: 30-Jul-2019
162 次瀏覽
廣告