Solution : https://service.sap.com/sap/support/notes/79094 (SAP Service marketplace login required)
Key words :
symptom incorrect optimization behavior, additional key words optimizer, regular 'update statistics' runs, sapdba -updstat -threshold 0 -logfile <, execute 'update statistics', optimal access path, update statistics, optimizer strategy, function 'updstat', current 'sapdba
Related Notes :
79134 | Object search performance in class.system (INFORMIX) |
76324 | 'Forced' update Statistics on individual tables |
38401 | Download the latest SAPDBA version |
29873 | Informix: Performance analysis of SELECT Statements |