[SERVER-6542] query optimizer does not consider query plans for $and:[$or:[conditions]] Created: 20/Jul/12 Updated: 07/Mar/14 Resolved: 26/Feb/13 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 2.0.6 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Arie Grapa | Assignee: | Aaron Staple |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
any |
||
| Issue Links: |
|
||||||||
| Operating System: | ALL | ||||||||
| Participants: | |||||||||
| Description |
|
I have 2 sets of "ored" conditions because I need all rows that meet conditions A or B or C, and that also meet conditions D or E or F. , {B}, {C}],$and[{$or:[ {D}, {E}, {F}]}] I think we need either a mechanism to specify multiple first level $ors (I know JS does not make it easy) or a smarter query optimizer that considers more alternatives, even if they are hidden inside an $and. |
| Comments |
| Comment by Aaron Staple [ 26/Feb/13 ] |
|
Hi Arie - This is |