|
Problem IT26872
|
Status: Geschlossen |
OPTIMIZER INCLUDES THE COST OF TEMP CREATION FOR EACH RE-USE IN THE ACCESS PLAN
|
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
When an internal temporary table is created by a SQL statement
and this temp table is re-used somewhere else in the optimizer
access plan, the cost of creating the temp is accounted for
multiple times.
This behaviour will not affect the access plan choice, but it
could affect WLM as the multiple counting of the same temp table
creation might increase the overall cost of the plan. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* See SYSROUTE APARs to see where this APAR is addressed *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : IT11514
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.11.2018
07.11.2018
07.11.2018 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
