|
Problem IT07125
|
Status: Closed |
DB2 might perform poorly for not existential subqueries containing column store tables |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
DB2 might depict slow performance if the following conditions
are satisfied:
1) The query has one or more NOT EXISTS subqueries
2) The subquery reference one or more column store tables
3) At least one of the correlated predicate is on these column
store tables
4) The column referenced in the correlated predicate(s) are part
of a primary/unique key. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 version 950 fix pack 6 (v10.5.0.6) *
**************************************************************** |
| Local Fix: |
db2set DB2COMPOPT=ALLOW_COMPLEX_SQ |
| Solution |
Fix is delivered in DB2 version 950 fix pack 6 (v10.5.0.6) |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.02.2015
26.08.2015
26.08.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.0
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.6
|
 |
| 10.5.0.7
|
|
