Can I create a index for array in mongodb?

Question

This is a record in mongodb.

{
  numbers: [1,2,3,4,5]
}

As title, If I create an indexing in mongo like

{
  numbers: 1
}

It will works? Or index works only on single value like number or string type?

John · Accepted Answer · 2020-11-25 08:57:21Z

4

Yes, you can and it works:

To index a field that holds an array value, MongoDB creates an index key for each element in the array. These multikey indexes support efficient queries against array fields. Multikey indexes can be constructed over arrays that hold both scalar values 1 (e.g. strings, numbers) and nested documents.

please visit the doc: Mongodb documentation

answered Nov 25, 2020 at 8:57

John

2,7614 gold badges21 silver badges35 bronze badges

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

1 Comment

Chicky Over a year ago

Thank you. The example is nested array so I miss it

Collectives™ on Stack Overflow

Can I create a index for array in mongodb?

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