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.