Chapter 4.2: MongoDB Indexes
Lab 4.2.2: Optimizing Compound Indexes
I need some help with the lab.
I find it hard to decide which index best suits all the queries.
It seems that every query is best served by a different index so there is no one particular index that serves all.
At first glance I thought the best compound index that would fit would be address.state and job or maybe address.state job and first name.
Both answers are wrong and I would appreciate it if you could explain why.