Or Query in mongodb

Working with Data
1

Say i have people collection,

{
   "_id":{
      "$oid":"57d7a184fa937f710a7e017a"
   },
   "last_name":"Acosta",
   "quote":"Ab quasi ullam vel sapiente eum unde nihil voluptates.",
   "job":"Clinical cytogeneticist",
   "ssn":"603-27-7608",
   "address":{
      "city":"West Danielle",
      "state":"Connecticut",
      "street":"87093 Jackson Corner",
      "zip":"96100-0593"
   },
   "first_name":"Renee",
   "company_id":{
      "$oid":"57d7a184fa937f710a7e016f"
   },
   "employer":"Smith, Jones and Alvarado",
   "birthday":{
      "$date":"2010-09-05T10:15:51.000Z"
   },
   "email":"katie97@walters-mann.com"
}

I want to write a query to fetch all people whose first_name starts with A or all people living in city Connecticut . What kind of index should i use , can i even use index to optimize this query.
indent preformatted text by 4 spaces

2

You achieve the OR thing of (first_name_starts_with_A) OR (people_living_in_city_Connecticut) using the operator https://docs.mongodb.com/manual/reference/operator/query/or/

You search for first_name_starts_with_A using https://docs.mongodb.com/manual/reference/operator/query/regex/

As for people_living_in_city_Connecticut, you use the $eq operator as defined in https://docs.mongodb.com/manual/reference/operator/query/eq/.

Since you posted your question in M201 of MongoDB university, I feel it is better for your learning if we point you to the documentation rather than give you a straight answer because you need to be acquainted with the documentation to be proficient.

Give a man a fish and you will feed him for the day, teach him how to fish and you will feed him for the rest of his life