Prioritizing the documents from two collections

Hi @Anil_kumar_Narreddi and welcome to the MongoDB Community forum. :wave:

To help you better, we would need certain information with respect to the above request.

  1. What do you mean when you refer to improve better? What are the metric that you are trying to improve?
  2. What is the aggregation query that you are trying to use ?
  3. What is the collection size for both the above mentioned collections?
  4. Do you have any index defined in the above collections?
  5. Can you also share the explain output for the aggregation query you are using?

Answering the above questions would help us identify the gaps and help the community to triage better.

Regards
Aasawari

2 Likes