[YSQL] Improve JOIN planning and execution
m-iancu opened this issue · 0 comments
m-iancu commented
As mentioned in #4496, currently the ybc access method (ybcin.c) does not support mark and restore position(ammarkpos
and amrestrpos
) for merge joins.
We should implement those and than enable merge joins for the relevant use-cases.
Additionally for the supported algorithms/cases (e.g. nested loop, hash joins) we can do a better job of estimating the costs and rowsize for the join nodes.