|
Problem IT08615
|
Status: Geschlossen |
USE OF TEMPORAL TABLES TOGETHER WITH EXISTENTIAL SUBQUERIES CAN LEAD TO SUBOPTIMAL PERFORMANCE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
Use of temporal tables together with existential
subqueries can lead to suboptimal performance
Under rare scenarios, DB2 might depict slow performance and
suboptimal access plan if the following are true:
1) The query contains one or more temporal tables
2) The query contains one or more existential subqueries
3) The parent of the correlation in the subquery is one of the
temporal tables |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5 fixpack 7 *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
Problem was first fixed in DB2 version 10.5 fixpack 7 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 29.04.2015
22.01.2016
22.01.2016 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.7
|
 |
