[SERVER-68444] Extend Heuristic CE for Sargable node to take into account Traverse Created: 01/Aug/22 Updated: 29/Oct/23 Resolved: 24/Oct/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.2.0-rc0 |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Timour Katchaounov | Assignee: | Alya Berciu |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | M1 | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||
| Sprint: | QO 2022-08-22, QO 2022-10-31 | ||||||||
| Participants: | |||||||||
| Description |
|
Heuristic CE for SargableNode should be symmetric to the analogous estimates for FilterNode. FilterNode increases selectivity by 10% when the path expression of a condition contains a PathTraverse node because this assumes there may be array data in the path. This task should do the same for heuristic estimation of SargableNode. The information about the path is stored inside the key of PartialSchemaRequirements, so should be easy to check. |
| Comments |
| Comment by Githook User [ 24/Oct/22 ] |
|
Author: {'name': 'Alya Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}Message: |
| Comment by Alya Berciu [ 19/Aug/22 ] |
|
This has to wait for the completion of |