SERVER-139247Blocked

Investigate impact of disagg on WT assumptions in the JOO cost model

Investigate which WiredTiger assumptions baked into the JOO cost model ({{{}join_cost_estimator_impl.cpp{}}}, {{{}join_estimates.cpp{}}}, {{{}catalog_stats.cpp{}}}, {{createCatalogStats()}} in {{{}executor.cpp{}}}) break under disaggregated storage and investigate if this can lead to poor plan quality. *Assumptions that could be wrong* * {_}Random IO is 5.4x sequential IO{_}{*}.{*} Disagg has no sequential locality. * {_}Per-page IO costs are ~160us sequential and ~864us random{_}{*}.{*}

Affected Versions
Versions known to exhibit this issue

No affected versions recorded.

Fixed Versions
Versions that include the fix

No fix available yet.

Components
Server components related to this issue

No components specified.

Labels
Tags and classification

No labels assigned.