Solution : https://service.sap.com/sap/support/notes/1794297 (SAP Service marketplace login required)
Summary :
This SAP Note discusses methods to address high CPU consumption and poor performance due to absent indexes for OLTP type selects on large tables in HANA databases. Users are guided to use reports SHDB_INDEX_ANALYZE, SHDB_INDEX_CREATE, and SHDB_INDEX_CHECK to identify and create beneficial secondary indexes on highly selective non-primary key fields. Implementation prerequisites, methodology including data analysis, and transport of indexes across systems are detailed, with emphasis on testing and validation to ensure system efficiency. Implementation of preliminary notes and analysis of index creation necessity as per system evolution are advised.
Key words :
subsequentsap_appl616616 ea-appl616616 sap_basis740740 sap_aba740740 support packages & patches support packagessoftware componentreleasesupport packagesap_appl616sapkh61601sap_aba740sapka74002ea-appl616sapk-61601ineaappl references, customer component han-db sap hana database priority correction, high priority category performance validity software componentfrom rel, sap hana db 1774566 sap business suite - restrictions 1768031 sap ehp 6, sap hana db 1774566 sap business suite - restrictions 1856484 corrections, hana - release information note 1821999 rapid database migration, sap hana attachments file namefile size, __%pdfstyle%__ / } symptom poor performance, sap notes 1961938 st-pi 2008_1_ sp09, data base indexthe ddic activation logs
Related Notes :
| 1961938 | ST-PI 2008_1_* SP09: Enhancements in functionality |
| 1905978 | Secondary Indexes for CRM for Utilities on HANA |
| 1856484 | Corrections for SHDB_INDEX_ANALYZE |
| 1813244 | |
| 1786384 | Missing secondary indexes for SAP HANA DB |
| 1774566 | SAP Business Suite - Restrictions |
| 1768031 | SAP EHP 6 for SAP ERP 6.0, version for SAP HANA |
| 1730175 | EHP2 FOR SAP SCM 7.0 ON HANA - Release Information Note |
| 1730098 | EHP2 FOR SAP CRM 7.0 ON HANA - Release Information Note |
| 1730095 | EHP6 FOR SAP ERP 6.0 ON HANA - Release Information Note |
| 1951144 | Beneficial secondary index: Financial category and group |
| 1888461 | SAP Auto-ID on HANA: Delete Obsolete Database Indixes |
| 1826384 | PPM 6.0: Performance notes |
| 1826332 | FAQs - SAP Portfolio and Project Management 6.0 |
| 1821999 | Rapid database migration of SAP Business Suite to SAP HANA |