Given the index and query below, the planner does NOT produce a covered plan (a FETCH stage appears). The most precise reason is:

db.orders.createIndex({ status: 1, qty: 1 }) db.orders.find( { status: "A", qty: { $gt: 50 } }, { status: 1, qty: 1 } // _id not excluded )