DB2 - Problembeschreibung
Problem IC65082 | Status: Geschlossen |
IN DB2 V9.7, AUTOMATICALLY REWRITE OR PREDICATE IN SELECT DISTINCT QUERY INTO UNION OPERATOR | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
An OR predicate that involves a table join is evaluated as a Sargable predicate at runtime. The OR predicate can already be converted to UNION operator by DB2 query rewrite. As result each OR subterm predicate can become efficient start-stop key predicate. Such rewrite requires certain conditions. One of them is the query must be SELECT with DISTINCT, and another is the OR hosting SELECT operator must have no join predicate between OR referenced tables and any other table. The latter condition is relaxed by this enhancement. An example is: SELECT DISTINCT ... WHERE T1.X = T2.X AND ( T1.Y = T3.Y AND T2.Z=1 OR T1.Y = T4.Y AND T4.Z = 1 ) The SELECT has a join predicate T1.X=T2.X, in which T1 is referenced by OR predicate but T2 is not. This enhancement enables the conversion from OR to UNION. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users with the mentioned query construction. * **************************************************************** * PROBLEM DESCRIPTION: * * An OR predicate that involves a table join is evaluated as * * aSargable predicate at runtime.The OR predicate can already * * be converted to UNION operatorby DB2 query rewrite. As * * result each OR subterm predicatecan become efficient * * start-stop key predicate.Such rewrite requires certain * * conditions. One of them is thequery must be SELECT with * * DISTINCT, and another is the ORhosting SELECT operator must * * have no join predicate betweenOR referenced tables and any * * other table.The latter condition is relaxed by this * * enhancement. Anexample is:SELECT DISTINCT ...WHERET1.X = * * T2.XAND (T1.Y = T3.Y AND T2.Z=1OR T1.Y = T4.Y AND T4.Z = * * 1)The SELECT has a join predicate T1.X=T2.X, in which T1 * * isreferenced by OR predicate but T2 is not. This * * enhancementenables the conversion from OR to UNION. * **************************************************************** * RECOMMENDATION: * * Upgrade to fix pack 3 or another release of DB2 * * whichcontains the fix. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 3. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.12.2009 27.09.2010 27.09.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3 | |
Problem behoben lt. FixList in der Version | |
9.7.0.3 | |
9.7.0.3 |