[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: |
|
||||||||||||||||
| Assigned Teams: |
Query Execution
|
||||||||||||||||
| Participants: | |||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||
| 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? |