SAP Note 873286 - Unloading/loading SAP MaxDB statistics data

Composant : MaxDB -

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

Mots Clés :
sap maxdb optimizer requires current statistics, dataload table sysstatistics outfile '/tmp/sysstat, update sysstatistics set schemaname='< sapsid>', def' outfile '/tmp/sysstat, sql studio/database studio, /sapdb/data/wrk/copy, sap maxdb version 7, owner='<sapsid>'               replace, 6 support package lower, system table sysdba

Notes associées :

1396431Table lock during UPDATE STATISTCS ESTIMATE (sampling)
927882FAQ: SAP MaxDB Update Statistics
870690Using DB13C to update statistics for remote MaxDB instances
129352Homogeneous system copy with MaxDB (SAP DB)