I have run the below query db.getCollection('COL1').find( { "type": "A", "dt_tm" : { $gte: ISODate("2020-08-17 00:00:00.000Z"), $lt: ISODate("2020-09-17 00:00:00.000Z")} }, {_id:0, "type":1, "dt_tm":1 } ) There is an index on the type and dt_tm column, qu…

Hello @vinodkumar_Mallikarj , In the first query, it was a case of Covered Query . The query was served by the index alone. That means, the index doesn’t have to lookup the documents for any additional details. The query filter and the projection are covered by the index fields. Here the FETCH stag…

Query is performing poorly even after using the index

Working with Data

vinodkumar_Mallikarj (Vinodkumar Mallikarjunaiah) October 20, 2020, 5:49am 4

Then how to handle of large amount of data with aggregation…?