-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
In WT-17175 and WT-18059, the storage engine added an API to get the approximate number of pages a b-tree contains. The join optimizer consumes this value in SERVER-129082. This API may return a sentinel value indicating the statistic is unavailable. In the join optimizer's metrics collection, we should indicate how many times this occurs as it can allow us to debug bad plans if we see this estimate being unavailable.
- is related to
-
WT-17175 Expose lightweight stat for approximate leaf page count per table
-
- Closed
-
-
WT-18059 Use a reserved marker value to mark untracked row-store leaf-page count/avg stats
-
- Closed
-
-
SERVER-129082 Use WiredTiger's approximate leaf page count in cost calculations
-
- Closed
-