db.colectionName1.aggregate([ { $match: { "filed1": { $in: ["x", "y"] }, } }, { $lookup: { from: "colectionName2", localField: "_id", foreignField: "xy", as: "matchedDate" } }, { $match: {

Working with Data
1

help to get optimized query , taking long time, any alternate methods

2

Please update the title of your post to something more comprehensible.

Please provide the complete pipeline.

Please provide the explain plan of your query.

Please provide sample documents.