Hello, so - i’ve started using Mongo Atlas, and in our application we needed to seperate by tenants, The suggestion was to create a field with a tenant_id in one collection and use single one while filtering the tenant_id (because if we would seperate collection per tenant / db per tenant - we would have to duplicate indexes which will be expensive).
So, we’re always filtering by tenant_id.
we have let’s say 6-7 more fields which we wanted to define a wildcard index on, as we don’t know how customer will perform the search.
so - is it possible to create an index that always tenant_id is indexed, and then a wildcard so it can choose the best fitted field to use? (as i know wildcard index uses only one field).
thanks.