Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Push down selections into joins #19792

Open
orlp opened this issue Nov 14, 2024 · 0 comments
Open

Push down selections into joins #19792

orlp opened this issue Nov 14, 2024 · 0 comments
Labels
A-ops Area: operations A-optimizer Area: plan optimization A-plan Area: logical plan and intermediate representation accepted Ready for implementation performance Performance issues or improvements

Comments

@orlp
Copy link
Collaborator

orlp commented Nov 14, 2024

Currently we don't do a projection pushdown into joins if a column is used as part of the key but not thereafter. These columns can be removed from the payload after row encoding/hashing. This is something would need to be pushed into the join operator itself however and can't just be done in the planner.

@orlp orlp added performance Performance issues or improvements A-optimizer Area: plan optimization A-ops Area: operations A-plan Area: logical plan and intermediate representation accepted Ready for implementation labels Nov 14, 2024
@github-project-automation github-project-automation bot moved this to Ready in Backlog Nov 14, 2024
@orlp orlp changed the title Push down selections into/past joins Push down selections into joins Nov 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-ops Area: operations A-optimizer Area: plan optimization A-plan Area: logical plan and intermediate representation accepted Ready for implementation performance Performance issues or improvements
Projects
Status: Ready
Development

No branches or pull requests

1 participant