[JBoss JIRA] (TEIID-5212) Additional optimization of left outer joins
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-5212?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-5212.
-----------------------------------
Fix Version/s: 10.1
Resolution: Done
Updated the outer join planning logic to look for additional associative scenarios that
span a left outer join - rather than looking only across a single nested join. The logic
is still not entirely general as the left hand structure must be simple (where we can
descend to an applicable access node).
Additional optimization of left outer joins
-------------------------------------------
Key: TEIID-5212
URL: https://issues.jboss.org/browse/TEIID-5212
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 10.1
Related to TEIID-5016 and TEIID-3652, there are additional circumstances where the join
planning logic can combine tables from different parts of a join tree involving left outer
joins.
The referenced forum posting has a star join against ora_ses such that moving the
placement of the nested inner join allows for more grouping of the join tables.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
3015
days inactive
3015
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)