You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/07/13 12:42:04 UTC
[GitHub] [incubator-doris] EmmyMiao87 opened a new issue #6225: New Join Reorder
EmmyMiao87 opened a new issue #6225:
URL: https://github.com/apache/incubator-doris/issues/6225
# background
The current JoinReorder algorithm mainly sorts according to the star model, and only considers the query association relationship between the table and the table.
His problem is:
1. Only applicable to user data whose data model is a star model, data of other models cannot be sorted.
2. Regardless of the cost consumption of the table, it is impossible to determine the size of the join table relationship, and the real query optimization ability is weak.
3. It is not possible to avoid possible time-consuming joins such as cross joins by sorting.
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman closed issue #6225: New Join Reorder
Posted by GitBox <gi...@apache.org>.
morningman closed issue #6225:
URL: https://github.com/apache/incubator-doris/issues/6225
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org