databend icon indicating copy to clipboard operation
databend copied to clipboard

feat: extend join condition dedup to anti/semi joins

Open SkyFan2002 opened this issue 1 week ago โ€ข 3 comments

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):

This change isโ€‚Reviewable

SkyFan2002 avatar Dec 11 '25 13:12 SkyFan2002

Docker Image for PR

  • tag: pr-19097-bbc829d-1765464017

note: this image tag is only available for internal use.

github-actions[bot] avatar Dec 11 '25 14:12 github-actions[bot]

@codex review

SkyFan2002 avatar Dec 12 '25 02:12 SkyFan2002

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".