metesynnada opened a new issue, #5715: URL: https://github.com/apache/arrow-datafusion/issues/5715
### Is your feature request related to a problem or challenge? Currently, `SymmetricHashJoin` requires order information before the `PipelineFixer`, leading to unnecessary sort and distribution enforcement requirements that impact optimizer performance. ### Describe the solution you'd like I would like to propose revamping `SymmetricHashJoin` to remove the dependency on order information before `PipelineFixer`. This would eliminate the need for unnecessary sort and distribution enforcement, leading to improved optimizer performance. ### Describe alternatives you've considered NA ### Additional context NA -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@arrow.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org