SAP Note 808060 - Changing the estimated values for Update Statistics

Composant : MaxDB - BW MaxDB

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

Mots Clés :
transaction db50-> problem analysis -> tables/views/synonymsfor, optimizer chooses inefficient access strategies, avoid undesired line breaks, encounter general performance problems, regularly perform update statistics, large tablesvery large tables, correct access strategy, online transaction processing, important additional information, change operations occur

Notes associées :

1466524MaxDB: SAMPLE values for update statistics
1396431Table lock during UPDATE STATISTCS ESTIMATE (sampling)
1308217SAP MaxDB Version 7.8: Parameter recommendations
1229738Parallel update statistics as of MaxDB 7.6.05 or 7.7.04
9726487.5.00.37: View access error (-3007)
958182Update Statistics and table DBSTATC
927882FAQ: SAP MaxDB Update Statistics
830468FAQ: Business Information Warehouse system with SAP MaxDB
819641FAQ: SAP MaxDB Performance
819324FAQ: SAP MaxDB SQL optimization
797667Performance problems in BW system require update statistics