Not all slow MongoDB queries are bad queries. Sometimes the query is fine, but MongoDB does not have a good index to help with your filtering, sorting, and retrieving of the data In this tutorial, we'll use payments as an example of our database. The collection starts without a useful index for our query. We'll identify the slow operation, learn about the recommended index, explain why the compound index works, and manage it visually in VisuaLeaf . The workflow is simple: slow query -> query profiler -> index recommendation -> compound index -> index manager You can use the same workflow when your own MongoDB collections start to feel slow. On this page The Slow Query Problem The Payments Query We Want to Optimize Find the Slow Query in VisuaLeaf Read the Index Recommendation Why This Compound Index Works Check and Manage Indexes Indexing Mistakes to Avoid FAQ The Slow Query Problem MongoDB can return results quickly when a collection is small.…