Table Reorganization

[Former Member]

From our early watch report we have received the following recommendation for Table Reorganization.

We have successfully re-indexed all tables/indexes through brtools as per note #332677 and 44595.

The problem we are facing is that after indexing the Tables/Index, the same recommendation is occurring into next early watch report.

Please find the attachment for further details.

0.1 Table Reorganization

When analyzing your database, we found large or rapidly growing tables or indexes.

Recommendation: Implement the SAP Notes listed below to reduce the size of some of these tables or indexes.

Background: For more information about Data Volume Management, see SAP Service Marketplace at service.sap.com/dvm[http://service.sap.com/dvm].

Recommended SAP Note 332677, 44595

Table / Index Name Size of Table / Index [MByte]

CROSS~PRO 320,0

D010TAB~0 3949,0

D010TAB~1 3368,0

REPOSRC~SPM 209,0

[debasissahoo]

Hi,

Check in DB02, how much size does the table and its index take.

Go to DB02, go to Detail analysis > Give CROSS* as object and execute. it will show you the size of table (CROSS) as well as the size of the indexes (CROSS~*). You can get an overview of how much size the index is taking.

If you see index size is lot higher than the table itself, then follow this.

(be very careful while doing this)

SE14 > give CROSS in table name, execute.

Now you should see the Utility for database tables.

Choose "Index" button on the top left. it wil show the available index. Now you've to choose the one which is giving warning in EWA and taking much size which you 've verified from DB02.

Now you should see "Utility for Database Index" screen.

Choose "Activate and adjust database". (VERY CAREFUL, DONT CLICK ON DELETE DATABASE INDEX)

This has to be done when not much activities are going on in system.

In the same way you can do for other index as well.

Hope this helps,

Debasis.