What is the right index for an Aggregation which matches with _id´s and sorts by date?

[Prasad_Saya]

@Steffen_Meyer

So my question is how should my index look like to get the most performant response and why is it that index?

Hello Steffen,

To start with please take a look at the following post, and it has somewhat similar issue about using a compound index with matching and sorting: Index scan not filtering as expected

EDIT Add: Also, please include the query plan results in the post.