Solution : https://service.sap.com/sap/support/notes/927882 (SAP Service marketplace login required)
Summary :
This SAP Note addresses frequently asked questions on MaxDB Update Statistics, specifically clarifying the process and types of statistics, their generation, and relevance for system optimization. It covers various aspects such as the definition, necessity, and creation of both table and column statistics. Additionally, it provides guidance on safe generation of statistics during production, the use of transaction DB13 for statistic management, and the significance of update operations in various SAP system releases. Recommended practices for estimating statistics using samples and setting appropriate sampling values are also discussed, ensuring efficient database performance management.
Key words :
alter table <tablename> sample 0 rowsoralter table <tablename> sample 0 percentyou, construct unnecessarily large interim resulting sets, pwd> db_execute update statistics estimatethe advantage, relevent sql statement takes longer, database system determines basic statistical information, statistical values returns exact data, transaction db50 -> tables/views/synonyms, join statement takes place, statement 'update statistics table' creates, join-transition involving joins
Related Notes :
| 1466524 | MaxDB: SAMPLE values for update statistics |
| 1396431 | Table lock during UPDATE STATISTCS ESTIMATE (sampling) |
| 1308217 | SAP MaxDB Version 7.8: Parameter recommendations |
| 1229738 | Parallel update statistics as of MaxDB 7.6.05 or 7.7.04 |
| 1090349 | Update table statistics for InfoCubes |
| 1082952 | Two (or more) schemas in an MaxDB instance |
| 1050755 | A1S with MaxDB: Performance problems in live update |
| 1010076 | SQL error -3009 when you update statistics |
| 928037 | FAQ: SAP MaxDB indexes |
| 873286 | Unloading/loading SAP MaxDB statistics data |
| 870690 | Using DB13C to update statistics for remote MaxDB instances |
| 863143 | Changing the upper and lower limits of the UPD_CHECK |
| 846890 | FAQ: SAP MaxDB Administration |
| 830468 | FAQ: Business Information Warehouse system with SAP MaxDB |
| 819324 | FAQ: SAP MaxDB SQL optimization |
| 808060 | Changing the estimated values for Update Statistics |
| 797667 | Performance problems in BW system require update statistics |
| 207133 | Update statistics with SAP DB 6.2 and higher |