|
Problem IC87878
|
Status: Geschlossen |
DB2 QUERY OPTIMIZER MIGHT CHOOSE A NON-OPTIMAL ACCESS PLAN FOR QUERIES INVOLVING JOINS ON SKEWED DATA |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
This is an extension to IC71258. You might encounter this
problem if your SQL statement is not performing optimally, one
or more joins in the query are on columns with significant skew
in one side of the join, one of the columns in the join is
unique, but the non-unique side of the join covers a larger
domain of values. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* This is an extension to IC71258. You might encounter this *
* problem if your SQL statement is not performing optimally, *
* one *
* or more joins in the query are on columns with significant *
* skew *
* in one side of the join, one of the columns in the join is *
* unique, but the non-unique side of the join covers a larger *
* domain of values. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10 Fixpack 2. *
**************************************************************** |
| Local-Fix: |
As described in IC71258, to solve this problem, a statistical
view can be created on the join, where applicable, to provide
the optimizer the appropriate information to account for the
skew. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
The fix will be included in DB2 Version 10 Fixpack 2. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.11.2012
31.12.2012
31.12.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
