Ansicht
Dokumentation

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

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

ROGBILLS - Synchronize billing plans   rdisp/max_wprun_time - Maximum work process run time  
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

BAL Application Log Documentation   General Material Data  
This documentation is copyright by SAP AG.

Length: 1007 Date: 20240302 Time: 153203     sap01-206 ( 2 ms )