Ansicht
Dokumentation

RJYDATU1 - Delete and Create Indices for Data Transfer

Description

When legacy data is transferred, a large amount of data is imported into the system. This would normally mean that data would have to be added to all indices belonging to a table every time an insert was performed. Since the records cannot be placed in a sort sequence that is suitable for all indices when the legacy data is imported, the storage quality of the indices becomes worse with each record. The indices should ideally be reorganized immediately. Moreover, mass update of a large number of indices is in fact also ineffectual.
This problem enables you to avoid these two problem areas by deleting the indices before data transfer. The deletion only applies to the database and the indices remain stored in the SAP Repository.
The import procedure now takes place without updating the indices immediately.
Once the legacy data has been imported successfully, the indices deleted must be reorganized. This can also be done using this program. The reorganization of the indices usually increases their storage quality greatly.

The program has the following parameters:

1. Data transfer object
   Specify the data transfer to be prepared in this field. The report uses this data to determine all indices in the system. If you have defined your own indices, they are also taken into account.
   The following data transfer objects are supported:
   - BP = Business partner
2. Delete indices before transfer
   This function deletes the indices for the selected data transfer object from the database. The function must be executed BEFORE data transfer.
3. Create indices after transfer
   This function creates the indices for the selected data transfer object on the database. This should be performed AFTER the transfer.

You should use batch processing to delete the indices before the transfer and, more importantly, to create new ones after the transfer. Creating indices is particularly likely to exceed the upper run time limit for dialog processing.

Requirements

This report can only be run in client 000.

Output

The report creates a list of all affected tables with their indices. The list indicates the result with which the required function was carried out for each index.