Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
TAJO-1352 is the issue to improve our join order optimization, but has a limitation. That is, when a query involves multiple commutative joins and non-commutative joins, the join order of commutative joins is fixed in an order of in an order of their occurrences in the query without optimization process.
This should be improved because the response time of a query will be highly increased due to the suboptimal join order as the query involves multiple joins.
Attachments
Issue Links
- requires
-
TAJO-1352 Improve the join order algorithm to consider missed cases of associative join operators
- Resolved