HomeProgramMongoDBCovered Query in MongoDB

Covered Query in MongoDB

What is Covered Query?

In the official MongoDB Documentation, a Covered Query is a query in which:

All fields in the query are part of an index and

All fields returned in the query are in the same index.

When all fields in the query are part of the index, MongoDB connects query conditions and returns the result by using the same index without looking inside the Document. When indexes are present in RAM, retrieving data from indexes is faster when compared to retrieving data by scanning all documents.

Use Covered Query in MongoDB

To study Covered Query, you follow the following Document in the user collection:

 { "_id" : ObjectId ( "53402597d852426020000002" ), "contact" : "987654321" , "dob" : "01-01-1991" , "gender" : "M" , "name" : "Tom Benzamin" , "user_name" : "tombenzamin" }

First, we create a complex index for users collection on the gender and user_name fields using the following query:

 > db . users . ensureIndex ({ gender : 1 , user_name : 1 })

Now, this index will cover the following query:

 > db . users . find ({ gender : "M" },{ user_name : 1 , _id : 0 })

It can be said that, with the above query, MongoDB will not go into searching for documents in the database. Instead, it will retrieve the necessary data from indexed data, which will make the process much faster.

When our index does not include the _id field, we explicitly exclude it from the result set of the query, because with MongoDB, by default it will return the _id field in each query. Therefore, the following query will not be covered within the index created above:

 > db . users . find ({ gender : "M" },{ user_name : 1 })

Finally, remember that an index cannot cover a query if:

Any indexed field is an array

Any indexed field is a Subdocument

According to Tutorialspoint

Previous article: Reference Database in MongoDB

Next lesson: Query analysis in MongoDB

3.8 ★ | 5 Vote

You should read it

May be interested

  • Query analysis in MongoDBPhoto of Query analysis in MongoDB
    analyzing queries is a very important aspect to assess the effectiveness of database and the effectiveness of the designed index. we will explore the two most frequently used queries, $ explain and $ hint.
  • Atomic Operation in MongoDBPhoto of Atomic Operation in MongoDB
    mongodb does not support atomic transaction over multiple documents. however, it provides atomic operations on a single document. therefore, if a document has hundreds of fields, the update command will either update all those fields or not update any fields, thus maintaining atomicity at the document level.
  • Advanced index operation in MongoDBPhoto of Advanced index operation in MongoDB
    create an index on the array ie create separate indexes for each of its fields. so in this situation, when we create an index on the array of tags, individual indexes will be created for their values: music, cricket and blogs.
  • Limitations of indexes in MongoDBPhoto of Limitations of indexes in MongoDB
    each index not only occupies part of the memory space but also causes an overhead on each insert, update, and delete operation. so, if you rarely use your collection for read operations, you should not use the index for it.
  • Map Reduce in MongoDBPhoto of Map Reduce in MongoDB
    in mongodb documentation, map-reduce is a data processing system that condenses a large amount of data into useful overall results. mongodb uses mapreduce command for map-reduce operation. in general, map reduce is used to handle large data sets.
  • Text Search in MongoDBPhoto of Text Search in MongoDB
    starting with version 2.4, mongodb started supporting text indexes to search within the string content.

MongoDB