Informix - Problembeschreibung
Problem IT02563 | Status: Geschlossen |
NEW OPTIMIZER CHOICE FOR SUBSELECTS IN 12.10 CAN CAUSE MASSIVE PERFORMANCE ISSUES TO CERTAIN QUERIES | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
12.10 has a new plan shape that's not allowed in 11.50, where we put all the subquery tables first and do a duplicate removal before joining in all the main query tables. Apparently in some cases the subquery tables are so large that the join among them is taking forever. There needs to be a fix so that this feature can be disabled, as it results in poor performance in some situations. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of 12.10.xC1 through 12.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-12.10.xC5 * **************************************************************** | |
Local-Fix: | |
No fix available | |
Lösung | |
Problem Fixed In IDS-12.10.xC5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.06.2014 16.10.2015 16.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
12.10.xC4.W1 |
![]() |
12.10.xC5 |
![]() |
12.10.xC5.W1 |
![]() |