[SERVER-74868] [CQF] Refine Costing for Spool-based RIN Created: 14/Mar/23  Updated: 20/Apr/23

Status: Open
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-69027 [CQF] Support for Recursive Index Nav... Closed
Assigned Teams:
Query Optimization
Participants:

 Description   

Currently we assign the group-level CE to all operators involved in the spool based RIN. Instead, for the inner distinct scans we should attempt to estimate the number of distinct values in order to allow costing to compute a more realistic plan cost. This can be some global heuristic (say 10% of the values are unique) or some simple function initially.


Generated at Thu Feb 08 06:28:45 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.