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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-4632:
----------------------------------
    Fix Version/s: 9.2


> 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
>             Fix For: 9.2
>
>
> 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.



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