Solution : https://service.sap.com/sap/support/notes/29873 (SAP Service marketplace login required)
Key words :
additional key words select sql performance index optimizer statistics sysdistrib, $ su - informix $ echo 'update statistics medium, $ su - informix $ dbaccess <sid> - > set explain, $ su - informix $ oncheck -ci <sid>, col1 col2 lower index filter, key fieldsthe construction date, cd 'sap service products', individual select statement appears, $ su - informix $ dbschema -, basic performance analysis
Related Notes :
| 79094 | SAPDBA: new features for 'update statistics' |
| 38401 | Download the latest SAPDBA version |
| 12184 | Improved performance with 'UPDATE STATISTICS' |