|
Problem IC63863
|
Status: Geschlossen |
OPTIMIZER USES FIRST TUPLE COST ONLY TO SELECT ACCESS PLAN |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
In a table with a large number of empty pages at the front of
the file, and a 0 cardinality, the optimizer uses First Tuple
Cost to select a plan. What the optimizer does not take into
account, when computing the First Tuple Cost, is that when the
table is empty, it will need to read the entire table to
discover it. Not just the first page of the table. There is a
similar issue with Index Scans - in that only the root page of
the index needs to be read to discover it is empty. The
optimizer does not currently fully, and properly deal with empty
indexes either. |
| Problem-Zusammenfassung: |
|
| Local-Fix: |
Running Reorg on a regular basis. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in FP5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.10.2009
17.02.2010
17.02.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
