home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList