DB2 - Problembeschreibung
Problem IT10858 | Status: Geschlossen |
IMPROVE DB2 PERFORMANCE FOR CORRELATED SCALAR SUBQUERIES WITH AGGREGATION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.08.2015 26.01.2016 26.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |