Skip to content

[YSQL] Improve JOIN planning and execution #4519

@m-iancu

Description

@m-iancu

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.

Metadata

Metadata

Labels

area/ysqlYugabyte SQL (YSQL)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions