Solution : https://service.sap.com/sap/support/notes/122839 (SAP Service marketplace login required)
Summary :
SAP Note addresses performance issues when displaying or deleting Report Writer extracts, linked to inefficient database accesses involving GRIX table. Table GRIX, crucial for report generation, lacks necessary indexes, causing significant performance degradation, confirmed since Release 4.5B. Resolution involves importing transport files K018282.P4B and R018282.P4B from SAP servers to establish indexes that optimize database interactions. Files can be found in directories specified for SAP servers sapserv3 to sapserv7. For further installation guidance, reference to SAP Note 13719 is recommended.
Key words :
additional key words gr55 sart extract extract management index, sgrw_perf_grep sgrw_performancesgrw_om sgrw_ps sgrw_pc sgrw_sl sgrw_pca sgrw_ec sgrw_lis, directory /general/r3server/abap/note, prerequisites missing database indexes, report writer extracts, performance ----- supportguide 20010208093844 -----reportwriter, database table grix, database accesses, table grix, time consuming
Related Notes :
| 353636 | Composite note 'Extract management' |