|
Problem IT07125
|
Status: Geschlossen |
DB2 might perform poorly for not existential subqueries containing column store tables |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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 |
| Lösung |
Fix is delivered in DB2 version 950 fix pack 6 (v10.5.0.6) |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 12.02.2015
26.08.2015
26.08.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.0
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.6
|
 |
| 10.5.0.7
|
|
