/* Find an order's detail */db.orders.find({ customerId: "f9437b18a248488827a75532", orderDate: { $gte: ISODate("2025-01-01T00:00:00Z") }}).sort({ orderDate: -1 }).explain("executionStats"),/*Create the compound index here*/db.orders.createIndex( { customerId: 1, orderDate: -1 }),/* Now, again find an order's detail */db.orders.find({ customerId: "f9437b18a248488827a75532", orderDate: { $gte: ISODate("2025-01-01T00:00:00Z") }}).sort({ orderDate: -1 }).explain("executionStats")
The explanation of the query is given below: