Index rebuilds/reorgs & Archive/Deletions

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

Post Reply
kikhan
Posts: 19
Joined: Sun Jun 01, 2003 2:47 am

Index rebuilds/reorgs & Archive/Deletions

Post by kikhan » Thu Aug 28, 2003 4:25 am

Hi,

We are doing a archiving exercise, and instead of reorging the tables we have decided to rebuild the indexes as the times and space is a issue. Would appreciate any advise on how to tackle the problem, as we only have a short window of time and are using the ALTER INDEX "A598______0" REBUILD ONLINE nologging; approach and are rebuilding all tables as cannot get a definitive list of tables hit by the archives and deletions. Not too sure if any of the following would work as a contiguous space requirement during the rebuild is also a problem, any help would be great:

1. Rebuild all indexes
2. Drop and recreat the Index tablespace and rebuild the indexes


Regards

KK

bubu
Posts: 529
Joined: Mon Oct 21, 2002 7:42 am

Post by bubu » Thu Aug 28, 2003 8:35 pm

Just curious, what's the size of your database? How much time is being alloted of this activity? And what's the scope of the archiving (e.g. all modules, what's the duration of the data that we're talking about that needs to be archived) ...

Regards,

Guest

Post by Guest » Fri Aug 29, 2003 3:25 pm

Hi,

The Database size id 550GB, the modules to archive MM/PP, SD & FI/CO. The time to run the rebuild of the indexes is 24 hours, which we have tested and should be achievable.

Regards

KK

Guest

Post by Guest » Mon Sep 08, 2003 9:00 am

Hi,

Does no one at all have any experience in rebuilding indexes, would appreciate any ideas onn this topic.

Regards


KK

Guest

Post by Guest » Thu Sep 18, 2003 4:33 am

Hi,

Would appreciate any advice and details on best method or approach to rebuilding all the indexes after a archiving run, thanks in advance. I was thinking of trying the following, not sure if this will work and if it is the best option:


1. Rebuild all indexes
2. Drop and recreat the Index tablespace and rebuild the indexes


Regards

KK

Post Reply