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