Details
-
Improvement
-
Resolution: Duplicate
-
Minor - P4
-
None
-
None
-
None
-
Fully Compatible
Description
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?
Attachments
Issue Links
- is related to
-
SERVER-2109 Query optimizer should pick plans that can use covered indexes
-
- Closed
-