[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:
Duplicate
is duplicated by SERVER-37751 Creating indexes for HINT only Closed
Related
related to SERVER-15600 Support for explaining query solution... Backlog
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.


Generated at Thu Feb 08 03:38:06 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.