[teiid-issues] [JBoss JIRA] (TEIID-4632) Clarify in doc's when a MAKEDEP temp table push down will be performed

Van Halbert (JIRA) issues at jboss.org
Thu Dec 8 17:04:00 EST 2016


Van Halbert created TEIID-4632:
----------------------------------

             Summary: Clarify in doc's when a MAKEDEP temp table push down will be performed
                 Key: TEIID-4632
                 URL: https://issues.jboss.org/browse/TEIID-4632
             Project: Teiid
          Issue Type: Enhancement
          Components: Documentation
    Affects Versions: 9.2
            Reporter: Van Halbert
            Assignee: Steven Hawkins
            Priority: Critical


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 could be forced.  

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.




--
This message was sent by Atlassian JIRA
(v7.2.3#72005)


More information about the teiid-issues mailing list