Combine the optimization rules `decorrelate`, `decorrelate_lateral_join`, and `decorrelate_predicate_subquery` into one.
- 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?
related to: #16015
```
It would be really nice to figure out how to combine these passes into one unified set of decorrelation code -- now we have three passes
```
### Describe the solution you'd like
_No response_
### Describe alternatives you've considered
_No response_
### Additional context
_No response_
Contributor guide
Research direction
Start by reading the three named optimization rules: `decorrelate`, `decorrelate_lateral_join`, and `decorrelate_predicate_subquery`, then review the related discussion in issue #16015. Done means the three passes are combined into one unified decorrelation pass without losing their existing behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- rust
- Domain
- databases
- Issue type
- Refactor
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100