[Join Optimization] Implement compact plan summary for join plans and expose in slow query logs

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Slow query logs show a planSummary. For single table query these show the relevant index(es). For join queries, this summary is more complex as we need to display the join order and algorithms as well.

      One idea is to implement a compact shorthand in functional style:

      HJ(Ixscan(A), INLJ(Collscan(B), Probe(C)))

            Assignee:
            Alya Berciu
            Reporter:
            Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: