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

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Planner/Optimizer
    • 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

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

              Dates

                Created:
                Updated: