Mongodb Pymongo create an index for nested object

Question

I have an object like so:

{
    "field1": "somestring",
    "field2": {
        "nestedfield1": "somestring",
        "nestedfield2": "somestring"
    }
}

i can create an index on field1 like so db.collection.createIndex('field1') and it will work as expected. But what if I want an index on both nested fields.

Do I have to do db.collection.createIndex('field2.nestedfield1') to create that index or will db.collection.createIndex('field2') automatically create that?

I will be searching using 'field2.nestedfield1' in my queries and want an index for that.

Thanks

daemon24 · Accepted Answer · 2017-11-18 04:48:11Z

1

You can't index nested field at once, you have to index each item inside separately.

To create an index on the nested field, just give its full field path with . separator,

db.collection.createIndex('field2.nestedfield1')

answered Nov 18, 2017 at 4:48

daemon24

1,4483 gold badges12 silver badges24 bronze badges

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

1 Comment

tung Over a year ago

Is it possible to create index at field2 and query using {field2: {"nestedfield1": "sth", "nestedfield2": "sth"}}?

Collectives™ on Stack Overflow

Mongodb Pymongo create an index for nested object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related