|
Problem IT08615
|
Status: Closed |
USE OF TEMPORAL TABLES TOGETHER WITH EXISTENTIAL SUBQUERIES CAN LEAD TO SUBOPTIMAL PERFORMANCE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5 fixpack 7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem was first fixed in DB2 version 10.5 fixpack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.04.2015
22.01.2016
22.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
|
 |
