2010YOUY01 opened a new issue, #16176:
URL: https://github.com/apache/datafusion/issues/16176
### Is your feature request related to a problem or challenge?
It would be great to add an example under `datafusion-examples` to
illustrate the following:
1. Default Planning and Optimization Strategy
- What is the default strategy for planning and optimizing queries with
joins: How does the engine decide the physical join type (e.g., sort-merge join
vs. hash join)?
- How is the join order determined?
Introducing the high-level internal optimization strategy can help users
better understand and perform their own optimizations.
2. Example Queries and EXPLAIN Output
- Provide example queries and show how the default policies optimize
them.
- Explain how to interpret the output of the `EXPLAIN` statement.
3. Relevant Configuration Settings
Include explanation for the related configurations (note that some
settings might not yet be supported in DF):
- If multiple physical join types are applicable, how can a user disable
or prefer a specific join type?
(e.g., for a simple inner join with equality conditions, how to force a
Nested Loop Join in the execution plan)
- How to override the join order?
(e.g., the optimizer chooses `t1`, `t3`, `t2` but the user prefers
`t1`, `t2`, `t3`)
- Any other relevant configuration options.
### Describe the solution you'd like
_No response_
### Describe alternatives you've considered
_No response_
### Additional context
_No response_
--
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...@datafusion.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
