Solution : https://service.sap.com/sap/support/notes/12184 (SAP Service marketplace login required)
Summary :
Key words :
menu function 'goto -> check -> table statistics -> sizes / statistics', 'goto -> activity -> current statistics -> table activity', short log entry including statistic, $informixdir/sapreorg/updstat_<sid>, additional key words db13, 'edit -> update statistics -> display, optimizer requires current information, action 'update optimizer statistics, weekly 'update statistics' run, update statistics optimizer
Related Notes :
| 536900 | Activating ODS: Error in creating SID - RSM1 187 |
| 332490 | Restrict selection report RMCUINOBTOIBASEMARA III |
| 328509 | Restrict selection report RMCUINOBTOIBASEMARA II |
| 316212 | Restricting selection report RMCUINOBTOIBASEMARA I |
| 301305 | Restrict selection criteria RMCUINOBTOIBASEMARA |
| 192423 | Delivery Processing Performance: Consulting |
| 184760 | Update Statistics: SAPDBA Rel.>=4.6A old strategy |
| 173993 | Cluster: System settings during Euro LC changeover |
| 143956 | Update Statistics: SAPDBA Release 4.5x new strategy |
| 66322 | CCMS: Database administration (transaction DB13) |
| 29873 | Informix: Performance analysis of SELECT Statements |