Solution : https://service.sap.com/sap/support/notes/85558 (SAP Service marketplace login required)
Key words :
sapr3/sap<sid>/sapsr3/sap<xyz>, sqlplus <sapuser>/<password>rename, extensive index range scan, long [raw] type field, long raw field, delete table <table_name>_old, primary key constraint, nested loop join, table structure export, symptom poor performance
Related Notes :
1016172 | Sorting table records during reorganization |
947139 | Poor performance when system reads documents |
832343 | FAQ: Clustering factor |
806554 | FAQ: I/O-intensive database operations |
541538 | FAQ: Reorganization |
96296 | CC-ERROR: Database problem in client copy |
86315 | Classif.system - find obj.fnctn, improved resp.time |