|
Problem IC77537
|
Status: Geschlossen |
IMPROVE THE HANDLING OF CONVERSION TO NLJOIN FROM MULTIPLE IN PREDICATES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problembeschreibung: |
If a query WHERE clause contains more than one simple IN
predicates whose IN operand is base column and IN elements are
composed of only literals, DB2 query compiler can convert one of
them to NLJOIN. It is possible that the compiler converts a
suboptimal IN predicate rather than the optimal one. The fix
makes sure the converted IN predicate is the optimal one.
Local fix: Use optimizer profile option "<INLIST2JOIN
OPTION="ENABLE" TABLE="TABLE_NAME" COLUMN="COLUMN_NAME"/>.
Replace TABLE_NAME and COLUMN_NAME with the real name of the IN
predicate dedicated to DB2 compiler for attempting the IN to
NLJOIN conversion. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* If a query WHERE clause contains more than one simple IN *
* *
* predicates whose IN operand is base column and IN elements *
* are *
* composed of only literals, DB2 query compiler can convert *
* one of *
* them to NLJOIN. It is possible that the compiler converts a *
* *
* suboptimal IN predicate rather than the optimal one. The fix *
* *
* makes sure the converted IN predicate is the optimal one. *
* *
* *
* *
* Local fix: Use optimizer profile option "<INLIST2JOIN *
* *
* OPTION="ENABLE" TABLE="TABLE_NAME" COLUMN="COLUMN_NAME"/>. *
* *
* Replace TABLE_NAME and COLUMN_NAME with the real name of the *
* IN *
* predicate dedicated to DB2 compiler for attempting the IN to *
* *
* NLJOIN conversion. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to latest fix pack. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 15.07.2011
09.08.2011
09.08.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.8.0.4
|
 |
