[SERVER-72615] Compute cardinality estimates for statistics computed with sampling Created: 08/Jan/23 Updated: 29/Oct/23 Resolved: 24/Jan/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.3.0-rc0 |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Misha Tyulenev | Assignee: | Alya Berciu |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Query Optimization
|
||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||
| Sprint: | QO 2023-02-06 | ||||||||
| Participants: | |||||||||
| Description |
|
CE should use the sample rate to multiply the final estimate. Let's say if sample rate 0.5. then we should multiply each estimate by 2. All per-type counters have to be scaled as well, not just the histogram-based estimates. |
| Comments |
| Comment by Githook User [ 25/Jan/23 ] |
|
Author: {'name': 'Alya Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}Message: |
| Comment by Githook User [ 24/Jan/23 ] |
|
Author: {'name': 'Alya Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}Message: |