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 })