Solution : https://service.sap.com/sap/support/notes/928037 (SAP Service marketplace login required)
Summary :
This SAP Note addresses frequently asked questions about indexes in MaxDB, liveCache, content server, and SAP DB databases. It offers detailed responses about the creation, structure, usage, and management of indexes intended for these databases. This guidance covers technical specifications, such as B* tree structures in indexes and how they enhance data retrieval speeds. Further, it discusses actions like creating and deactivating indexes, considerations for designing indexes efficiently, and methods for managing index states and performance. The note does not cover all possible questions but provides significant guidance for common concerns and operations related to managing indexes in SAP database systems.
Key words :
create index parallel - final index statistics + perm leaf pages 348 - record count 11411create index parallel - start final merge stepcreate index parallel - temp pages 42 - temp files 2create index parallel - stop final merge step [count 1]savepoint, transaction db50 -> problem analysis ->tables/view/synonyms -> optimizer statistics, maxdb/livecache /content server/sap db databases, data records'leaf pages' number, parallel index creation, parallel index build, server tasks transfer processing back, <tablename> init usagein transaction db50, transaction db50 -> problem analysis -> indexes, files knldiag
Related Notes :
| 1344000 | Emergency shutdown during access to a clustered index |
| 927882 | FAQ: SAP MaxDB Update Statistics |
| 819641 | FAQ: SAP MaxDB Performance |
| 819324 | FAQ: SAP MaxDB SQL optimization |
| 771929 | FAQ: Index fragmentation |
| 767598 | Available SAP MaxDB documentation |
| 566883 | Bad indexes after software upgrade 7.3.00 Build 27 |
| 436664 | -602 system error: BD index not accessible |
| 167394 | SAP MaxDB: BAD INDEX |
| 26837 | MaxDB: Data corruption, error -9026/-9028 |