-
Type:
Improvement
-
Resolution: Works as Designed
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
None
-
Query
Case insensitive indexes should be used when running a case insensitive "starts with" regex like this /^searchterm/i
Currently if you make a case insensitive collation and run a "starts with" regex query like this /^searchterm/i, mongodb will not use the index. This is a real problem for any application that uses an autocomplete feature.