Table reorganization.

[Former Member]

Hi Gurus,

I am in maintanence job

I would like to know the tabele reorganization of some particular tables.

1. Please, give an eg of how to do a Table reorganization.

2. if we reorganizize for all the tables in the database is it called as database reorganization.?

Windows,4.7, 9i

Regards

VK

[Former Member · Accepted solution]

Hi,

check SAP Note 541538 - FAQ: Reorganizations

regards,

kaushal

[Former Member]

Hi

1. You have to use SAPDBA->Reorganization (d)->Reorganize single table orindex

(c)->Table or index (b) ,and other parameters

or from the tcode DB13

2. Yes it is database reorganize.

During reorganisation index are rebuilded, after that you must

regenerate objects of system to optimize response time.

Regards

Bhaskar