MongoDB

How to diagnose a slow MongoDB query with explain(), tell a missing-index problem apart from other causes, and fix it with the right index — including compound-index field order.

How MongoDB’s aggregation pipeline works, stage by stage — $match, $group, $sort, $project — with a worked example that goes from raw documents to a summary report.