-
Type:
Task
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
Fully Compatible
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Added `onDiskSizeBytes` field to `CollectionStats` to track the compressed on-disk size of collections, separate from the existing `logicalDataSizeBytes` which represents uncompressed in-memory size.
- Modified join cost estimator to use on-disk size instead of logical size for I/O cost calculations in:
- Collection scan fragment costing
- Index scan fragment costing
- Index nested loop join fragment costing
- Updated all test fixtures and expected test outputs to include the new field
- Test helper now sets on-disk size to 1/4 of logical size to simulate compression
This change improves cost estimation accuracy by using actual compressed storage size when calculating disk I/O costs for query execution plans.
- related to
-
SERVER-122512 [Join Optimization] Investigate TPC-H Q9 choice to use INLJ probe into lineitem
-
- Open
-