[SERVER-67166] Heuristic CE for SargableNode Created: 10/Jun/22 Updated: 29/Oct/23 Resolved: 19/Jul/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.1.0-rc0 |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Timour Katchaounov | Assignee: | Timour Katchaounov |
| 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-06-13, QO 2022-06-27, QO 2022-07-11, QO 2022-07-25 | ||||
| Participants: | |||||
| Linked BF Score: | 168 | ||||
| Description |
|
Implement heuristic CE for SargableNode that takes into account the actual predicates (or equivalent intervals). That is, compute specific
Each of the cases above will have a different default selectivity, which also depends on the actual collection cardinality. Consider using metadata for estimation (if already not used):
|
| Comments |
| Comment by Githook User [ 22/Jul/22 ] |
|
Author: {'name': 'Timour Katchaounov', 'email': 'timour.katchaounov@mongodb.com', 'username': 'timourk'}Message: Make PhysRewriter/FilterIndexing3MultiKey more stable on |
| Comment by Githook User [ 19/Jul/22 ] |
|
Author: {'name': 'Timour Katchaounov', 'email': 'timour.katchaounov@mongodb.com', 'username': 'timourk'}Message: |