DB2 - Problembeschreibung
Problem IT26278 | Status: Geschlossen |
INDEXES ON COLUMN-ORGANIZED TABLES ARE NOT CHOSEN FOR SOME TYPESOF SQL STATEMENTS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
There are some situations where indexes on column-organized tables can provide significant performance improvements but they are not chosen by the optimizer. For example: create table tc1 (pk1 int not null, pk2 int not null, c1 int, c2 int, c3 int) organize by column; create unique index tc1pk on tc1 (pk1,pk2); select * from tc1 where exists ( select c1 from tc1 g where g.pk1 = tc1.pk1 group by pk1,c1 having count_big(*) >= 1000) order by pk1,pk2; Index TC1PK might've been a faster way to access table TC1 in the EXISTS subquery, depending on the data characteristics. The issue tends to occur when the potential index access occurs in sub-selects or sub-queries. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher * **************************************************************** | |
Local-Fix: | |
Use an optimization guideline to force the desired index access. | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.09.2018 27.11.2018 27.11.2018 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |