In MongoDB Indexes, it is explained that we should consider the index prefixes for better read performance. When it comes to CRUD optimization, ESR rule is explained as best practice for index. Can someone explain about this. ? How the index should be designed?
The compound indexes are preferable and more efficient to use despite of creating multiple single field indexes.
The order of the fields should follow the ESR rule.
I would recommend you to go through the following Blog:
Please feel free to reach out if you have any questions.