Solution : https://service.sap.com/sap/support/notes/418185 (SAP Service marketplace login required)
Summary :
The prolonged runtime of the RC1PHDEL report in the Specification Management module of Product Safety is due to inefficient database queries. Current selection strategies result in the database optimizer inefficiently handling large datasets with complex WHERE conditions. The remedy is restructuring the SQL queries to harness the primary table index more effectively. This optimization, which eliminates the use of OR conditions in the WHERE clause, is available in EHS 2.5B SP 06 and EHS 2.7B SP 01, enhancing performance significantly.
Key words :
additional key words ehs27bsp01psehs25bsp06psperformancedb_setget, prerequisites causethe system reads, specification managementthe runtime, master data matchup, missing deletion flags, data records marked, attached correction instructions, actn_old = key_tab-actn, recn_old = key_tab-recn, actn > actn_old
Related Notes :
| 1429324 | Improvement of the runtime behavior of RC1PHDEL |
| 1406547 | Program RC1PHDEL requires excessive runtime |
| 395095 | Corrections EH&S 2.5B: Support Package 06 |
| 391318 | EH&S 2.7B corrections: Support Package 01 |