In my query I have the first stage with $match to filter common conditions. And I want to perform a different set of conditions on the result set, hence using $facet. In the documents I saw $facet stage doesn’t use indexes. Probably because of this reason my query is very slow. Here’s my data look …

Improving MongoDB queries having $facet stage

steevej (Steeve Juneau) December 27, 2021, 2:24pm 4

I am still thinking about it but have nothing to propose so far that can be done in a single DB access.