[teiid-issues] [JBoss JIRA] (TEIID-4005) Allow dependent join row value to be split
Steven Hawkins (JIRA)
issues at jboss.org
Fri Feb 26 14:33:00 EST 2016
[ https://issues.jboss.org/browse/TEIID-4005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-4005:
----------------------------------
Description:
For some queries having a dependent join row value that spans multiple target tables should be split among those targets.
For example rather than:
(g_0.e1, g_1.e2) IN (<dependent values>))
Use the pre 8.7 form:
(g_0.e1 IN (<dependent values>)) AND (g_1.e2 IN (<dependent values>))
was:Potentially an oracle query optimization issue. Row value predicate for particular tables are more performant when splitting into two in predicates.
Summary: Allow dependent join row value to be split (was: optimization to split row value predicate into two predicates)
> Allow dependent join row value to be split
> ------------------------------------------
>
> Key: TEIID-4005
> URL: https://issues.jboss.org/browse/TEIID-4005
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 8.7.4.6_2
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5
>
>
> For some queries having a dependent join row value that spans multiple target tables should be split among those targets.
> For example rather than:
> (g_0.e1, g_1.e2) IN (<dependent values>))
> Use the pre 8.7 form:
> (g_0.e1 IN (<dependent values>)) AND (g_1.e2 IN (<dependent values>))
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list