XieJiann opened a new pull request, #36035:
URL: https://github.com/apache/doris/pull/36035
## Proposed changes
This PR optimizes query performance by pushing down aggregations through
joins when grouped by a foreign key. This adjustment reduces data processing
overhead above the join, improving both speed and resource efficiency.
Transformation Example:
Before Optimization:
```
Aggregation(group by fk)
|
Join(pk = fk)
/ \
pk fk
```
After Optimization:
```
Join(pk = fk)
/ \
pk Aggregation(group by fk)
|
fk
```
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
