Suggestions for better schema design for searching names

[Prasad_Saya]

@yannick

Do you think it will automatically use “owner_1_search_1” once I have more data? Or should I just use “hint()”?

You probably has multiple indexes, and the query optimizer is not able to select the one you want. What indexes are there you can find using the db.collection.getIndexes(). And, you can generate a Query Plan and see how indexes are being applied using the explain() method on the query.

In general, I think using of hint is not encouraged. Having more data doesn’t allow selection of a particular index, I think. How index is selected for a query depends upon:

What determines, which index needs to be used in case there are multiple indexes (with common fields) defined for a collection?

Hello @Amin_Memon, here are some clarifications. Which one of the indexes would be used? In theory, any of the indexes could be used. In case, if there was a compound index on (list_type, 1) + (user_email, 1), it would be a candidate too. In your case, ideally, a compound index comprising the two fields should be created and that would be used. Since, there is a possibility of using the two fields in two combinations, you need to determine which is the best. This can be determined in the wa…