Answer
Queries must match index collation; otherwise MongoDB cannot use the index and falls back to collection scans.
Quick Answer
Collation defines language-specific string comparison rules (case sensitivity, accent sensitivity, sort order). Indexes are collation-aware - an index with a specific collation can only be used by queries with the same collation. A query with collation won't use a standard index. Create the index with the same collation your queries use, or the query planner falls back to a collection scan.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ