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-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

Reply via email to