DB2 - Problembeschreibung
Problem IT27081 | Status: Geschlossen |
SAP: SUBOPTIMAL PERFORMANCE FOR QUERIES WITH INEQUALITY PREDICATES ON COLUMNIZED TABLES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
Suboptimal performance can be observe when running a query with the following characteristics: 1. the query runs on columnized tables 2. the query contains an equality predicate and an inequality predicate 3. the inequality predicate can be rewritten to containing only constants and host variables based on the equality predicate An example query: select 1 from col_table where c19 and c1=:HV | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local-Fix: | |
manually rewrite the inequality predicate. The example query can be rewritten to: select 1 from col_table, (select * from values(0) where :HV9) where c1=:HV | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.11.2018 16.01.2020 16.01.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |