MongoDB – Covered Queries

In this chapter, we will learn about covered queries.

What is a Covered Query?

As per the official MongoDB documentation, a covered query is a query in which −

• All the fields returned in the query are in the same index.
• All the fields in the query are part of an index.
  Since all the fields present in the query are part of an index, MongoDB matches the query conditions and returns the result using the same index without actually looking inside the documents. Since indexes are present in RAM, fetching data from indexes is much faster as compared to fetching data by scanning documents.

  Using Covered Queries

  To test covered queries, consider the following document in the empDetails collection −

  {
  "_id" : ObjectId("602372d4f7661885eff39c92"),
  "userId" : "rirani",
  "jobTitleName" : "Developer",
  "firstName" : "Romin",
  "lastName" : "Irani",
  "preferredFullName" : "Romin Irani",
  "employeeCode" : "E1",
  "region" : "CA",
  "phoneNumber" : "408-1234567",
  "emailAddress" : "romin.k.irani@gmail.com"
  }

  We will first create a compound index for the emp collection on the fields gender and user_name using the following query −

  > db.emp.createIndex({"userId":1,"region":1})
  {
  "createdCollectionAutomatically" : false,
  "numIndexesBefore" : 1,
  "numIndexesAfter" : 2,
  "ok" : 1
  }
  >

  Now, this index will cover the following query −

  > db.emp.find({"userId":"rirani"},{"region":1,_id:0})
  { "region" : "CA" }

  That is to say that for the above query, MongoDB would not go looking into database documents. Instead it would fetch the required data from indexed data which is very fast.
  Since our index does not include _id field, we have explicitly excluded it from result set of our query, as MongoDB by default returns _id field in every query. So the following query would not have been covered inside the index created above −

  > db.emp.find({"userId":"rirani"},{"region":1})
  { "_id" : ObjectId("602372d4f7661885eff39c92"), "region" : "CA" }
  >

  Lastly, remember that an index cannot cover a query if −

• Any of the indexed fields is an array
• Any of the indexed fields is a subdocument