DB2 - Problem description
Problem IT10858 | Status: Closed |
IMPROVE DB2 PERFORMANCE FOR CORRELATED SCALAR SUBQUERIES WITH AGGREGATION | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
This enhancement improves DB2 performance when the following conditions are true: 1) The SQL query is either SELECT,UPDATE or DELETE 2) The query references column organized tables 3) The query contains one or more correlated scalar subqueries 4) The correlated predicates are equality join predicates 5) There does not exist any primary or unique key across all the predicate columns eg. Select * From T1 Where T1.C1 = 1 and T1.C2 = (Select max(c2) from T2 where T1.c3 = T2.c3); | |
Problem Summary: | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.08.2015 26.01.2016 26.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |