Ansicht
Dokumentation
05014 - Deleting unused indexes to save space. Is it s afe ?
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up ABAP Short ReferenceThis documentation is copyright by SAP AG.
Deleting unused indexes to save space. Is it s afe ?
Hi Steve,I'm sorry, but I really would NOT believe in these figures at all!
As SAP is accessing the database on with the table or the view-name, I'm
pretty unsure, if this date gets updated at all.
You could try, but please do not complain afterwards!
Regards
Volker
P.S.: On the other hand you could test this with SQL and a test-lib
yourself, if you prefer.
> -----Original Message-----
> From: Jones, Stephen [mailto:Steve_JonesZH...]
> Sent: Montag, 11. Februar 2002 12:56
> To: 'Sap400 (E-mail)'
> Subject: 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]
>
>
> ------------------------ consolut Sponsor
> ---------------------~-->
> Sponsored by VeriSign - The Value of Trust
> Pinpoint the right security solution for your company - FREE
> Guide from industry leader VeriSign gives you all the facts.
> http://us.click.consolut.net/lWSNbC/WdiDAA/yigFAA/dkFolB/TM
> --------------------------------------------------------------
> -------~->
>
> Have a look to our homepage at: http://www.consolut.net
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to
http://www.consolut.net
Durban Tours - Südafrika Safari
CL_GUI_FRONTEND_SERVICES - Frontend Services Addresses (Business Address Services)
This documentation is copyright by SAP AG.
Length: 2876 Date: 20240425 Time: 033448 sap01-206 ( 3 ms )