-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
None
-
Query Optimization
I am using certain array compound indexes which are quite heavy. I've seen cases where these can slow down the query plan selection on queries where we do not intended to be used. (We call this the "Mongo Index Butterfly Effect".)
It would be very nice to be able to define something like "hint_only: true" on the index itself to prevent it from being used EXCEPT when it has been explicitly hinted.
- is duplicated by
-
SERVER-37751 Creating indexes for HINT only
- Closed
- related to
-
SERVER-15600 Support for explaining query solution in the presence of hypothetical indexes
- Backlog