SERVER-138160Open

Investigate cost model changes needed to pick cheaper INLJ on small table

For TPCE locust queries q08/q10/q14/q15/q17 it seems we prioritize a plan with a HJ/NLJ on a COLLSCAN instead of an INLJ probing on the "smaller" table. When comparing to classic, the classic plan is (closer) to an INLJ (probing on the small table). While the absolute difference is small (on the order of ~10s of docs) this cost is visible in terms of query latency because each query is very fast.

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.