Support Self Join Eliminate
Open
enhancement
- Dominant language
- Rust
- Stars
- 9.3k
- Forks
- 2.4k
- Avg merge
- 3d 7h
- Merged PRs (30d)
- 344
Description
### Is your feature request related to a problem or challenge?
PostgreSQL just landed elimination for the self joins for some queries
https://www.phoronix.com/news/PostgreSQL-Self-Join-Eliminate
Likely DataFusion can also benefit from it for queries like in TPCH Q21.
### Describe the solution you'd like
It could be an optimizer rule to rewrite the plan to avoid self joins for some conditions
### Describe alternatives you've considered
_No response_
### Additional context
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.