How To Fix RSD_TREX513 - Delta-Indizes für bestimmte Indizes vorschlagen ('&1')

SAP Error Message - Details

• Message type: E = Error

• Message class: RSD_TREX - Messages from TREX Aggregate Area

• Message number: 513

• Message text: Delta-Indizes für bestimmte Indizes vorschlagen ('&1')

Description
It is useful to create a delta index for large indexes that are often
updated with new data. New data is not written to the main index, but to
the delta index. This can significantly improve the performance of
indexing, since the "OPTIMIZE" step must only be executed on the smaller
amount of data from the delta index. The data from the delta index is
used at the runtime for the query.
The system determines the proposals from the statistics data: proposals
are indexes that received new data more than ten times during the last
ten days. A prerequisite for these proposals is that the statistics for
the InfoCube are switched on.
A "MERGE" should be executed for data in the main index and delta index
at regular intervals (see test "Size of Delta Index").
Repair
In repair mode, the system sets the <ZK>Has Delta Index</> property for
the proposed indexes. The delta index is created when the data is next
loaded for this index.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE