Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1683

Improve join order optimization of a query involving multiple commutative joins and non-commutative joins

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Planner/Optimizer
    • Labels:
      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

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jihoonson Jihoon Son
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: