Answer
$in can use indexes efficiently while $nin generally causes collection scans because it excludes values.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ