SAP Note 29873 - Informix: Performance analysis of SELECT Statements

Composant : Informix - System Administration

Solution : https://service.sap.com/sap/support/notes/29873 (Connexion à SAP Service Marketplace requise)

Mots Clés :
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

Notes associées :

79094SAPDBA: new features for 'update statistics'
38401Download the latest SAPDBA version
12184Improved performance with 'UPDATE STATISTICS'