|
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) |
