home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList