[SERVER-1649] Allows hints when multiple indexes are used Created: 21/Aug/10  Updated: 25/Jan/24

Status: Backlog
Project: Core Server
Component/s: Querying
Affects Version/s: 1.6.1
Fix Version/s: None

Type: New Feature Priority: Major - P3
Reporter: Scott Hernandez (Inactive) Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 16
Labels: asya
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Related
related to SERVER-22741 Ability to hint index intersection Backlog
is related to SERVER-17128 Apply index filters to individual $or... Backlog
Assigned Teams:
Query Execution
Participants:
Case:

 Description   

Currently for $or specifying a hint is ambiguous since more than one index can be used. It would be nice to have a syntax to specify a hint of/for multiple indexes.

I have no idea how to do this; Maybe you could specify a list and the query optimizer will try to the choose per query clause...

As the query optimizer gets more complex (and more than one index can be used per query) this is only going to become more of an issue.



 Comments   
Comment by Juan Ley [ 11/May/23 ]

Any tentative date for this enhancement?
https://support.mongodb.com/case/01091431

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