-
Type: Improvement
-
Resolution: Duplicate
-
Priority: Minor - P4
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
None
-
Fully Compatible
on a query such as :
> t.find(
{ q : /.*cde.*/ }).explain()
and other similar things, the query optimizer should consider using an index on
{ q : 1 }if it exists. the entire index would have to be scanned, but that will in some cases still be much faster than a table scan. (this is assuming a "covered index" approach - that iwll have to be verified too)
i think a hint works with the above now?
- is related to
-
SERVER-2109 Query optimizer should pick plans that can use covered indexes
- Closed