With a compound index { status: 1, createdAt: -1 }, a query filters status equality and sorts by createdAt ascending. Can the index avoid an in-memory sort?db.events.find({ status: "open" }).sort({ createdAt: 1 })
