Skip to main content
Journey Uncommon Logo
JourneyUncommon
hardMongoDBCovered queries internalsSingle-choice MCQ

This query runs against an index on { user: 1, status: 1 }. The explain output shows a FETCH stage above the IXSCAN. Why is this query NOT covered, and what single change would make it covered?

db.users.find( { user: "alice", status: "active" }, { _id: 0, user: 1, status: 1, createdAt: 1 } )