Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4632

Clarify in doc's when a MAKEDEP temp table push down will be performed

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Critical
    • 9.2
    • 9.2
    • Documentation
    • None

    Description

      Clarify in the documentation when the MAKEDEP temp table push down will be performed. It was tested and confirmed that by changing MaxInCriteriaSize to 1 and MaxDependentPredicates to 1 could force the temp table pushdown. So it would appear that when the number of independent values exceeds MaxInCriteriaSize*MaxDependentPredicates this would be performed (when Enabled Dependent Joins is true).

      So, on page 832 (pdf of 9.1)
      " .. then multiple dependent queries will be issued in parallel".
      May want to rephrase to say if "Enabled Dependent Joins" is true, that pushed down to temp table will occur, other wise, multiple dependent queries will be issued in parallel.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            van.halbert Van Halbert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: