MongoDB Multi-key Index: สร้างดัชนีบนอาร์เรย์ทั้งหมด

สร้างคอลเลกชันตัวอย่าง

> db.demo277.insertOne({"details":[{"FirstName":"John"}]});
{ "acknowledged": true, "insertedId": ObjectId("5e48fb21dd099650a5401a52") }
> db.demo277.insertOne({"details":[{"FirstName":"David"}]});
{ "acknowledged": true, "insertedId": ObjectId("5e48fb27dd099650a5401a53") }
> db.demo277.insertOne({"details":[{"FirstName":"Chris"}]});
{ "acknowledged": true, "insertedId": ObjectId("5e48fb2bdd099650a5401a54") }

แสดงข้อมูล

> db.demo277.find();

{ "_id": ObjectId("5e48fb21dd099650a5401a52"), "details": [ { "FirstName": "John" } ] }
{ "_id": ObjectId("5e48fb27dd099650a5401a53"), "details": [ { "FirstName": "David" } ] }
{ "_id": ObjectId("5e48fb2bdd099650a5401a54"), "details": [ { "FirstName": "Chris" } ] }

คิวรี: ค้นหา details.FirstName = "David" (Full Document Scan)

> db.demo277.find({"details":{FirstName:"David"}});

ผลลัพธ์

{ "_id": ObjectId("5e48fb27dd099650a5401a53"), "details": [ { "FirstName": "David" } ] }