[SERVER-15463] Exclude indexes from query plan (hint_only: true) Created: 30/Sep/14 Updated: 06/Dec/22 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Johnny Shields | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||
| Assigned Teams: |
Query Optimization
|
||||||||||||||||
| Participants: | |||||||||||||||||
| Description |
|
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. |