MongoDB Index on Embedded Fields

Question

This example is from the MongoDB documentation:

{
    "_id": ObjectId(...),
    "name": "John Doe",
    "address": {
        "street": "Main",
        "zipcode": "53511",
        "state": "WI"
    }
}

You can create an index on the address.zipcode field, using the following specification:

db.people.createIndex( { "address.zipcode": 1 } )

Does it mean that only one John Doe could live for the zip code 53511?

I'm a bit confused!

Frederick Cheung · Accepted Answer · 2015-10-25 05:43:46Z

1

It does not - it merely means that queries of the form

 db.people.find({"address.zipcode": "12345"})

Will be able to use that index rather than scanning the whole collection.

If the index where a unique one then it would prevent reuse of that zipcode across the whole collection

answered Oct 25, 2015 at 5:43

Frederick Cheung

84.3k9 gold badges156 silver badges175 bronze badges

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

Collectives™ on Stack Overflow

MongoDB Index on Embedded Fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related