Ansicht
Dokumentation

05014 - Deleting unused indexes to save space. Is it s afe ?

05014 - Deleting unused indexes to save space. Is it s afe ?

ROGBILLS - Synchronize billing plans   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

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

Addresses (Business Address Services)   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 2876 Date: 20240304 Time: 190159     sap01-206 ( 3 ms )