I’ve asked the following in the MongoDB University and was referred here:
Hi, playing with Compass I’ve noticed that if you use _id field in Find()
the indexStats accesses.ops field increases by 2, what is the explanation for this behavior? is it the same for all unique indexes matches?
Another thing, when using INSERT on a unique index field, I’d expect the accesses.ops to increase by 2 as the index uniqueness must be verified and only then inserted.
(and if the index is found to be duplicated an increase by 1 only)
I’d appreciate a clarification.