Solution : https://service.sap.com/sap/support/notes/1892354 (SAP Service marketplace login required)
Summary :
This SAP Note outlines necessary preconditions and guidelines for declustering and depooling SAP Business Suite tables running on non-HANA databases, ensuring systems are on SAP NetWeaver 7.40 SP3 or higher. It details the procedural and tool-based methods available, emphasizing the importance of careful pre-implementation considerations regarding potential space consumption increase and performance impacts. Recommendations for specific database platforms are provided, including tips on optimizing declustering based on the underlying database technology. Users are urged to validate impacts using a representative dataset before proceeding.
Key words :
customer component bc-db-dbi db independent database interface priority correction, low priority category consulting validity software componentfrom rel, software provisioning manager software provisioning manager, single unique index 1835008 activate additional database performance optimizations, sap ase microsoft sql server oracle database, cluster tables 1436352 oracle database 11g advanced compression, extras -> change/display table category, component bc-db-db6, component bc-db-db2, de-clustered/de-pooled tables
Related Notes :
| 1856270 | Performance improvements for tables with single unique index |
| 1109743 | Use of Index Key Compression for Oracle Databases |
| 1436352 | Oracle Database 11g Advanced Compression for SAP Systems |
| 1784377 | Checking pool tables and cluster tables |
| 1835008 | Activate Additional Database Performance Optimizations for SAP ERP |
| 2025349 | DB2-z/OS: Online conversion of tables (SE14, ICNV, REORG, ...) |