Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-2127 enhance Trafodion implementation of WITH clause
  3. TRAFODION-2315

Heuristic decision on when to use a temp table for WITH clause

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sql-cmp
    • Labels:
      None

      Description

      This is a follow-up to TRAFODION-2127.

      The code delivered for TRAFODION-2127 puts in the infrastructure to create a temp table, but it does not provide heuristics to decide automatically when to do this transformation. CQD CSE_USE_TEMP can only be used to force the transformation ON or OFF.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hzeller Hans Zeller
                Reporter:
                hzeller Hans Zeller
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: