Informix - Problem description
Problem IT37062 | Status: Closed |
INCREASE IN DS_TOTAL_MEMORY CAUSE CHANGE IN EXECUTION PLAN RESULTING IN DRASTIC SLOWNESS IN QUERY | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
High memory settings for below onconfig parameters can lead to optimizer choosing Nested Loop Join over Dynamic HASH Join which results in degraded query performance . DS_TOTAL_MEMORY DS_NONPDQ_QUERY_MEM | |
Problem Summary: | |
Local Fix: | |
Lower the values of these onconfig parameters or reset to defaults . | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.05.2021 10.10.2022 10.10.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |