|
Problem IT36743
|
Status: Closed |
PREVENT PUSHING DOWN LARGE IN LIST PREDICATES TO UNION BRANCHES.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
Prevent pushing down large IN list predicates to UNION branches.
Pushing down large IN list predicates (e.g. with thousands of
values) to each UNION branch may considerably increase the
section of an access plan.
Query characteristics:
+ Large IN list predicate applied above a UNION view
+ Internally, IN predicates are push down unconditionally to
each UNION branch |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.7 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.7 or later *
**************************************************************** |
| Comment |
Upgrade to 11.5.7 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.04.2021
02.12.2021
02.12.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
