Ansicht
Dokumentation

05011 - Deleting unused indexes to save space. Is it safe ?

05011 - Deleting unused indexes to save space. Is it safe ?

RFUMSV00 - Advance Return for Tax on Sales/Purchases   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Deleting unused indexes to save space. Is it safe ?

Hello all.

We have a bit of an ongoing disk space problem.

From running RTV and PRT DSKINF I can see table OBJK is nearly 12 % of the
total R/3 DB size. (JCDS is even bigger!!)

It has a number of indexes each of which are nearly 2 %. And some of these
have a last used date either way in the past or missing altogether.

I would like to remove these indexes to buy some breathing space.

Is it safe to do so ? Can I believe the last used date ?

Regards Steve Jones





[Non-text portions of this message have been removed]


Durban Tours - Südafrika Safari

rdisp/max_wprun_time - Maximum work process run time   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 1007 Date: 20240419 Time: 102000     sap01-206 ( 9 ms )