| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC86792 | Status: Geschlossen |
OPTIMIZER UNDERESTIMATES THE NUMBER OF EXPECTED ROWS IN A SORT /GROUP BY OPERATOR, WHICH LEADS TO A BAD PERFORMING ACCESS PLAN | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problembeschreibung: | |
A sample statement having a WHERE clause as shown below will
generate a plan where the expected row count in SORT / GROUP BY
operator is drastically less compared to actual number of rows.
statement:
SELECT...
WHERE tab1.col1 = 'xyz'
GROUP BY tab2.col2 ,
tab1.col1 ,....
Note: col1 is used in the GROUP BY clause
Plan generated will show estimated row count in SORT/GROUP BY
as 3 where the actual count is 13923.
0,000176497
1
NLJOIN
( 16)
1221,82
NA
/---+----\
0,000530024 0,332997
1 1
TBSCAN IXSCAN
( 17) ( 23)
1214,24 15,1398
NA NA
| |
3 -1
5469 NA
TEMP INDEX: SCHEMA1
( 18) IDX1
1214,23 Q42
NA
|
3
5469
GRPBY
( 19)
1214,23
NA
|
3
13923
TBSCAN
( 20)
1214,23
NA
|
3
13923
SORT
( 21)
1214,23
NA
|
19109
19109
TBSCAN
( 22)
1209,64
NA
|
19109
NA
TABLE: SCHEMA1
TABX
Q5 | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 2. * **************************************************************** | |
| Local-Fix: | |
| verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows | |
| Lösung | |
First fixed in DB2 Version 10.1 Fix Pack 2. | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.09.2012 09.04.2013 09.04.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |
| 10.1.0.2 |
|
| 10.5.0.2 |
|