Skip to main content
Journey Uncommon Logo
JourneyUncommon
hardMongoDBIndex intersectionSingle-choice MCQ

This query has two single-field indexes available: { a: 1 } and { b: 1 }, but no compound index. Under what specific internal condition will MongoDB use index intersection (AND_SORTED / AND_HASH) rather than picking just one index, and what is the usual outcome in practice?

db.users.find({ a: 5, b: 10 })