This is an $or query. That means all documents that match first condition, union with all documents that match the other condition. If you don’t have a separate index for each of the conditions it’ll need to do a collection scan anyway.
4 Likes