Informix - Problem description
Problem IT29969 | Status: Closed |
SELECT STATEMENT WITH LEFT JOIN AND SUBQUERY IS EXTREMLY SLOW | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
a statement with 5 left joins and a where condition of the form: WHERE a.a1>=(DATE("08/28/2017")-10) AND a.a2 IN ( 7 ) AND a.a3 IN ( SELECT b2t.t_fk FROM b2t WHERE b2t.b_fk=99 ) will run very slow without PDQ. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix 14.10.xC1. * **************************************************************** * PROBLEM DESCRIPTION: * * SELECT STATEMENT WITH LEFT JOIN AND SUBQUERY IS EXTREMELY * * SLOW * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
onmode -wf SQL_FEAT_CTRL2=0x10 | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.08.2019 19.09.2019 19.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
14.10.xC2 | |
Problem solved according to the fixlist(s) of the following version(s) |