Skip to content

Try out classical relational estimates as a cost function with e-graphs #3

@georgiy-belyanin

Description

@georgiy-belyanin

It is worth trying classical estimates for relational JOIN (i.e. for multiplication) and for recursive JOIN (i.e. for Kleene-star) combined with e-graphs to find the best plan. They can be obtained from `https://pure.tue.nl/ws/portalfiles/portal/341762557/20241031_Mulder_hf.pdf, from https://github.com/chernishev/Database-Engines-Course/tree/master/Lecture%203, slide 40.

These estimates can be calculated by maintaining two vectors, one reduced by rows, and the other one reduced by columns for adjacency matrix for each label. It is worth mentioning that these vectors should be estimated for each subtree and it can be non-trivial for non-leaf vertices.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions