How to index a MongoDB field that holds an array of strings?

Question

In my collection, documents will contain a field that holds an array like so:

{
  field_a: ["banna", "orange", "kiwi"]
}

How to index this collection based on this field?

The queries will be something like:

Find all documents where field_a is a subset of a given array.

Multikeys indexes exists in mongo but i'm not sure it's useful in your use case. It just splits the array so i'm not sure it's useful for mongo to determine if it's a subset. The thing you can do is to test it =) You can create a multikeys the same way you would create an index, just test it ! =) — JeanJacquesGourdin, Sep 22 '22 at 14:33

score 1 · Accepted Answer · answered Sep 22 '22 at 14:35

1

You can create an index like this:

db.col.createIndex({ 'field_a': 1 })

answered Sep 22 '22 at 14:35

NeNaD

Will this index work on the query that I described? – Bear Bile Farming is Torture Sep 22 '22 at 14:37
You want to send send an input array to a query, and `field_a` should have all the items of that array, right? If that is the case, then yes. – NeNaD Sep 22 '22 at 14:47

1 Answers1