Database
[{"collection":"test","count":100,"content":{"city":{"type":"enum","values":["Chicago","LA","NY"]},"gender":{"type":"enum","values":["M","F"]},"age":{"type":"int","min":13,"max":95}},"indexes":[{"name":"main_index","key":{"gender":1,"city":1,"age":1}}]}]
Query
db.test.aggregate([{$match:{"gender":"M","city":{$in:["Chicago","LA","NY"]},"age":{$lte:26}}}]).explain("allPlansExecution")