How to create index for the following kind of data in mongodb

Question

db.test.insert({a:1, b:[1])
db.test.insert({a:1, b: 1})
db.test.insert({a:[1], b: 1})
db.test.insert({a:[1], b: [1]})

what should be a right way to index the fields so that i can query over a and b?

John · Accepted Answer · 2020-06-25 09:20:10Z

1

{ _id: 1, a: [1, 2], b: 1, category: "A array" }
{ _id: 2, a: 1, b: [1, 2], category: "B array" }

A compound multikey index { a: 1, b: 1 } is permissible since for each document, only one field indexed by the compound multikey index is an array; i.e. no document contains array values for both a and b fields.

However, after creating the compound multikey index, if you attempt to insert a document where both a and b fields are arrays, MongoDB will fail the insert.

---- Documentation

But one of your doc's a & b both contain array.

answered Jun 25, 2020 at 9:20

John

2,7614 gold badges21 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mukul Anand Over a year ago

So for this kind of document scopes , any index is not possible ?

John Over a year ago

Documentation says so.

Collectives™ on Stack Overflow

How to create index for the following kind of data in mongodb

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related