feat: extend join condition dedup to anti/semi joins
I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/
Summary
Avoid redundant join conditions and runtime filters to improve performance.
TPC-H Q21: 45s->30s
Tests
- [x] Unit Test
- [ ] Logic Test
- [x] Benchmark Test
- [ ] No Test - Explain why
Type of change
- [ ] Bug Fix (non-breaking change which fixes an issue)
- [ ] New Feature (non-breaking change which adds functionality)
- [ ] Breaking Change (fix or feature that could cause existing functionality not to work as expected)
- [ ] Documentation Update
- [ ] Refactoring
- [x] Performance Improvement
- [ ] Other (please describe):
Docker Image for PR
- tag:
pr-19097-bbc829d-1765464017
note: this image tag is only available for internal use.
@codex review
Codex Review: Didn't find any major issues. Breezy!
โน๏ธ About Codex in GitHub
Codex has been enabled to automatically review pull requests in this repo. Reviews are triggered when you
- Open a pull request for review
- Mark a draft as ready
- Comment "@codex review".
If Codex has suggestions, it will comment; otherwise it will react with ๐.
When you sign up for Codex through ChatGPT, Codex can also answer questions or update the PR, like "@codex address that feedback".