yugabyte/yugabyte-db

[YSQL] Improve JOIN planning and execution

m-iancu opened this issue · 0 comments

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.