Solution : https://service.sap.com/sap/support/notes/365304 (SAP Service marketplace login required)
Key words :
multi-level consistency locking semantics, key field shows low selectivity, complete data records prior, attached report zsdeldis deletes, additional key words scc5, attached report zsdeltab locks, optimal deleting algorithm, needless database accesses, deleting algorithms hold, relevant support package
Related Notes :
857973 | Deleting clients efficiently using Oracle |
806554 | FAQ: I/O-intensive database operations |
541538 | FAQ: Reorganization |
489690 | CC INFO: Copying large production clients |
446485 | CC-ADMIN: Special copying options |
208919 | CC-INFO: Performance as of Release 4.6 |
206523 | CC-RELEASE: Client copy errors in 4.6C and 4.6D |
161495 | CC-RELEASE: Error in client copy in 4.6A and 4.6B |
96296 | CC-ERROR: Database problem in client copy |
70643 | CC-TOPIC: Client Deletion (SCC5) |
68896 | R3trans: Performance problems and cluster |
67205 | CC-INFO: Copying large and productive clients |
24853 | CC-INFO: Client copy, functionality |
22514 | CC-INFO: Error analysis for client copy |
19574 | CC-ADMIN: Controlling data selection during client copy |
15374 | Checklist: Performance analysis |
12621 | SAPDBA: speeding up a reorganization |